Camel case converter in an excel

user_2507805 0
Viewed 31048

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.

excel-2013 excel-formula excel
5 Answers

Try this:

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

enter image description here

user_48515900

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

user_146042070 
   =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.

user_1923540

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

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

using replace,

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

user_127723930
Related