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.