UPPER, lower & Proper in Excel
In an earlier post I discussed using len, left and right and mid. Now I will look at more functions that fall under “Text” in Excel – upper, lower and proper.
These 3 functions allow you to change the case of text in your files.
I usually use these functions on files that have been made up of information from a variety of people – some people may type in lower case, or upper case or a combination of both.
To keep everything consistent, I use either upper, lower or the proper function.
What do upper, lower & proper mean?
- APPLYING UPPER MAKES ALL THE TEXT UPPER CASE (CAPTIALISED)
- applying lower makes all the text lower case (not capials)
- Applying Proper Makes All The First Letters In Your Text Upper Case
We will apply these formulas to this text string:
UPPER
Cell B1 has our sample text.
In Cell B2, we will use the UPPER function and reference our sample text.
- Start the formula with =UPPER
- Open brackets
- Type B1 or click on the cell
- Close the brackets
The full text has been converted to all upper case.
LOWER
In Cell B3, we will use the LOWER function and reference our sample text.
- Start the formula with =LOWER
- Open brackets
- Type B1 or click on the cell
- Close the brackets
There is no difference here to our original text, because it was already in all lower case.
But if any of the original text was in upper case then it would have been changed to lower case.
PROPER
In Cell B4, we will use the PROPER function and reference our sample text.
- Start the formula with =PROPER
- Open brackets
- Type B1 or click on the cell
- Close brackets
The first letter of each word is now upper case, and the remaining letters are lower case.
[grwebform url=”http://app.getresponse.com/view_webform.js?wid=4307503&u=CucD” css=”on”/]
