PROPER(text)

Returns the text string with the first letter of every word as a capital letter.

text

The text string you want to convert.

Remarks

* The "text" can be a formula that returns text, or a cell reference containing text.* Letters that follow another letter will be converted to lowercase.* Letters that follow numbers will be capitalised.* Letters that follow punctuation characters will be capitalised.* Letters that do not follow another letter will be capitalised.* You can use the LOWER function to return a text string with all the characters converted to lowercase.* You can use the UPPER function to return a text string with all the characters converted to uppercase.* For the Microsoft documentation refer to support.office.com

A

1

=PROPER("some TEXT") = Some Text

2

=PROPER("better solutions") = Better Solutions

3

=PROPER("1a2b3c4d") = 1A2B3C4D

4

=PROPER("shouldn't") = Shouldn'T

1 - What is the text string "some TEXT" converted to proper case.2 - What is the text string "better solutions" converted to proper case.3 - What is the text string "1a2b3c4d" converted to proper case. Notice that all the letters are converted to uppercase because they follow numbers.4 - What is the text string "" converted to proper case. Notice that the letter 't' is converted to uppercase because it follows a punctuation character.