PROPER
Formats the text string in proper sentence format.
Formats the text string in proper sentence format.
Syntax of Excel Proper formula:
=PROPER(text)
In words:
=Change sentence format of text in proper format(text)
F14 has this sentence: hello from the other side
In cell F15 putting the formula =PROPER(F14) will result: Hello From The Other Side