PROPER

PROPER(text)

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

textThe 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
* For the Google documentation refer to support.google.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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top