Convert first letter into upper case

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

Regex

Tips and Tricks

Accepted answers

MarqueeCrew

Titlecase([Before])

That should work.

All comments

MarqueeCrew

Titlecase([Before])

That should work.

RodL

I would use the following Expression...

Uppercase(Left([Data], 1)) + Lowercase(Substring([Data],1,100))

The "100" at the end should be the maximum length of the string.

RodL

@MarqueeCrew

Dang, I make things so complicated. ;-p

I always forget about the TitleCase() function.

MarqueeCrew

Really @RodL?

Maybe I returned the favor to you.

BenMoss

titlecase() is definitely the way to go here, but we could also make RodL's formula dynamic (rather than stating the number of characters) by doing the following...