How to convert a word to first letter only, all uppercase, or all lowercase.(Microsoft Excel)
Here are some functions that manipulate strings of English words.
Contents
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.

---
Discussion
New Comments
No comments yet. Be the first one!