I would like to convert first letter into Upper case and rest is lower case.
I could use text to column tool and separate the first letter and the rest of letters. And I convert the first split into upper case, then the second split into lower case. Then combine them together. However, I am wondering if there is simpler way to convert the fist letter into Upper case at once.
@RodL In my dataset I have duplicate words in camelCase, some with an initial capital, some with the first letter lower case; as I didn't want to alter the case of the subsequent letters (a mix of upper and lowercase), I couldn't use Titlecase to homogenise the first letter, so your method has really helped me. Thank you!
Super old thread but Data Cleanse has a Modify Case option at the bottom and Title Case is one of the options. I know that wouldn't help with Sentence case but I wanted to add this in case anyone is searching for an easy way to set Up