Sometimes when you import text from another source it may not be formatted in the case you want. For example it may be ALL IN CAPITALS, all lower case, or a combination of the two.
There are a few functions in Excel that we can use to quickly fix the formatting of text, namely UPPER, LOWER and PROPER.
As you’d expect the:
- UPPER function changes all text to CAPITALS
- LOWER function changes all text to lower case
- PROPER function changes the first letter in each word to upper case and all other letters to lower case – this is useful for fixing names.
The syntax for each function is basic:
In the table below we can see how each function has altered the original text in column A.
Our formulas in row 6 for each function are as follows:
- Cell B6 =UPPER(A6)
- Cell C6 =LOWER(A6)
- Cell D6 =PROPER(A6)
Once you have converted your text to the format you prefer you can Copy and Paste Special > Values to the cell location you want.