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),"_","...
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.
6 Answers
Try this:
=LOWER(LEFT(A1)) & MID(SUBSTITUTE(PROPER(A1),"_",""),2,LEN(A1))
With Office 365 we can use:
=LET(
rr,A1,
x,TEXTSPLIT(rr,"_"),
CONCAT(LOWER(TAKE(x,,1)),PROPER(DROP(x,,1))))
Just use =PROPER(A1) on the another cell and you have it done.
You were so close! Just wrap your left expression in a LOWER:
=LOWER(LEFT(A1)) & RIGHT(SUBSTITUTE(PROPER(A1),"_",""), LEN( SUBSTITUTE(A1,"_",""))-1)
=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.
This converts to camel case:
=SUBSTITUTE(LOWER(LEFT(A5)) & MID(A5,2,LEN(A5)),"_","")
using replace,
=LOWER(LEFT(A1,FIND("_",A1)-1))&PROPER(REPLACE(A1,1,FIND("_",A1),""))
Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.
