The Excel PROPER function is a Text function, and its purpose is to capitalize the first letter in each word of a text. Learn how to use it.

You can change the case of a text string in Excel by using LOWER, UPPER, and PROPER, and they are all so simple to use.

Q. I read your August 2022 JofA article about changing the case of text in Excel to upper, lower, and proper, but some of my data comes in sentence form. Is there any way to convert those text strings ...