Convert first letter into upper case

[knozawa]

Hello,

I would like to convert first letter into Upper case and rest is lower case.

For example:

	Before	After
1	APPLE	Apple
2	banana	Banana
3	LeMoN	Lemon

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.

Sincerely,

Kazumi

[rohit782192]

Really good Solution

[TeePee]

@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!  

[knobsdog]

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