Here’s a breakdown of how to achieve camel case:
Convert to Proper Case: Use the PROPER() function to capitalize the first letter of each word in a string.
Remove Leading/Trailing Spaces: Use the TRIM() function to remove any leading or trailing spaces.
Make the First Word Lowercase: Use LOWER() to convert the first character of the string to lowercase.
Combine the First Character with the Rest of the String: Use REPLACE() to replace the first character with its lowercase version.
Optional: Remove Extra Spaces: Use SUBSTITUTE() to remove any extra spaces if needed.
Formula Example (Lower Camel Case):
=REPLACE (SUBSTITUTE (PROPER (TRIM(A1)),” “,””),1,1, LOWER(LEFT (TRIM (A1))))