PROPER

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 ISTEXT function to return the boolean True or False depending if the value is text.
* You can use the LOWER function to return a text string with all the characters converted to lowercase.
* You can use the SUBSTITUTE function to return a text string after replacing instances of a substring.
* 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.microsoft.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 "shouldn't" converted to proper case. Notice that the letter 't' is converted to uppercase because it follows a punctuation character.