Say you would like to automate the conversion of a bunch of strings into Java variable or method names.

Given that A1 has the original strings, you could use the formula below to create the corresponding camelCase version of the strings.

[code] =CONCATENATE(LOWER(LEFT(A1,1)),RIGHT(SUBSTITUTE(PROPER(A1),” “,””),(LEN(SUBSTITUTE(PROPER(A1),” “,””)))-1))
[/code]