What is the use of PROPER function?

PROPER Function in Excel returns the first letter in a text string or cell references of every word as a capital letter and all other letters in the string are converted to lowercase.

Any characters that are not text will not altered.

What is the syntax of PROPER function?

PROPER Function in Excel syntax
PROPER(text)
Where text : The text string you want to change.

PROPER Function in Excel – Examples

PROPER Function in Excel examples

Reference:

Please refer the below article for more Text Excel functions.
Text Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

Hey! Join Our Community

Get Quick Responses & Experts' Answers in Minutes!
Get Notified - When Answered Your Question!