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 |
|
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. |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top