Camel case converter in an excel

Question

I'm attempting to change the case of a field in an excel file called REC LEN. To do it, I'm using this formula.

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

This is producing outcomes similar to RecLen. I also want to change the case of my first letter (The expected output is recLen). Can someone please assist me with this? I don't have much experience with Excel formulas. I'm not sure if this has been asked before, but any assistance would be very appreciated.

Answer 1

Try this:

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