Here are some functions that manipulate strings of English words.
Converts first letter only to uppercase (PROPER function)
=PROPER(Text)
Name | Omission | Explanation |
---|---|---|
Text | Required field | Specify the target string. |
If there is more than one English word, convert the first letter of all words to uppercase.
Convert to uppercase (UPPER function)
=UPPER(Text)
Name | Omission | Explanation |
---|---|---|
Text | Required field | Specify the target string. |
If there is more than one English word, all words are converted to uppercase.
Convert to lower case (LOWER function)
=LOWER(Text)
Name | Omission | Explanation |
---|---|---|
Text | Required field | Specify the target string. |
If there is more than one English word, all words are converted to lowercase.
Spill
If you specify range of cells in string, it will be a Spill.
---