lower CamelCase in Google Sheets

Question

I was wondering if anyone had advice for creating a function that transformed text_with_spaces into lower camel case like textWithSpaces

I've found a related question on SO, that helps with regular camel case, but I'm not sure how to bring it to lower CamelCase

Provide a couple more sample data in a sample sheet. Are the words delimited by "_" or spaces? — TheMaster, Sep 21 '17 at 23:07

score 1 · Answer 1 · answered Sep 22 '17 at 05:05

ASSUMING It's just text with spaces,

Here's another answer using REPLACE and SUBSTITUTE:

=REPLACE(SUBSTITUTE(PROPER(TRIM(A1))," ",""),1,1,LEFT(LOWER(TRIM(A1))))

Using REGEX:

=REGEXREPLACE(REGEXREPLACE(PROPER(A1),"\s*",""),"^(\w)",LEFT(LOWER(TRIM(A1))))

score 0 · Answer 2 · answered Sep 22 '17 at 04:12

If to go from text_with_spaces to textWithSpaces try:

=left(A1)&mid(join("",arrayformula(proper(mid(split(A1,"_"),1,len(A1))))),2,len(A1))

If to go from text with spaces to textWithSpaces try:

=left(A1)&mid(join("",arrayformula(proper(mid(split(A1," "),1,len(A1))))),2,len(A1))

2 Answers2