'Camel case converter in an excel

I am trying to convert a field in an excel sheet (e.g. REC_LEN) to camel case. I am using this formula to do that

=LEFT(A1) & RIGHT(SUBSTITUTE(PROPER(A1),"_",""), LEN( SUBSTITUTE(A1,"_",""))-1)

This is giving me results like RecLen. I want to convert my first letter to lowercase too (The expected output is recLen). Can somebody help me out with this? I am not too familiar with excel formulae. Not sure if this has been already asked before but any help is much appreciated.

Solution 1:^[1]

Try this:

=LOWER(LEFT(A1)) & MID(SUBSTITUTE(PROPER(A1),"_",""),2,LEN(A1))

Solution 2:^[2]

Just use =PROPER(A1) on the another cell and you have it done.

Solution 3:^[3]

   =LOWER(LEFT(A1)) & MID(A1,2,LEN(A1))

This works perfectly for creating camel case when there is no space or underscore between words.

So HelloWorld will become helloWorld.

Solution 4:^[4]

You were so close! Just wrap your left expression in a LOWER:

=LOWER(LEFT(A1)) & RIGHT(SUBSTITUTE(PROPER(A1),"_",""), LEN( SUBSTITUTE(A1,"_",""))-1)

Solution 5:^[5]

using replace,

=LOWER(LEFT(A1,FIND("_",A1)-1))&PROPER(REPLACE(A1,1,FIND("_",A1),""))

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1
Solution 2	Baraka Mbega
Solution 3	Jobin
Solution 4	Chris Schaller
Solution 5

'Camel case converter in an excel

Solution 1:[1]

Solution 2:[2]

Solution 3:[3]

Solution 4:[4]

Solution 5:[5]