Search code examples
excelexcel-formulaexcel-2013

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

  • Try this:

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

    enter image description here

    With Office 365 we can use:

    =LET(
    rr,A1,
    x,TEXTSPLIT(rr,"_"),
    CONCAT(LOWER(TAKE(x,,1)),PROPER(DROP(x,,1))))

    enter image description here