Excel: Convert text to CamelCase
Strings can be converted to camel case notation in Excel with a combination of three functions. Just use the following formula in cells:
=SUBSTITUTE(PROPER(LOWER("text in camel case"));" ";"")
This example converts "text in CAMEL CASE" to "TextInCamelCase".
If you want to convert the text of another cell - for example, cell F5 - the cell number is simply referenced:
=SUBSTITUTE(PROPER(LOWER(F5));" ";"")
What do the individual functions of the formula do? First, LOWER() converts the entire text to lowercase letters. Afterwards, the initial letters of all words are capitalized with PROPER(). Finally, with SUBSTITUE() all blanks are removed.
