How to use the Excel Lower Upper case functions. We also show how to use the Proper Case formula.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
- - 2:31
- - Skill Level: 3
- - What's my skill level
Excel Lower Upper Case
In this segment you will learn how to use the Excel Lower Upper case functions. We also show how to use the Proper Case formula.
LOWER drops all letters to lower case, UPPER makes all the letters upper case, and PROPER will start each sentence with an upper case and follow it with lower case.
In this example we have a cell with text which is a bit messy in terms of its capitalisation. We are going to use these functions in Excel to neaten the cell up.
If we would like the text in this cell to all be lower case, we can use the LOWER function. In that case
- You click on a cell
- You activate the function wizard
- You can go to either All, or you can go straight to the Text category
- And if you go down, you’ll see there’s a LOWER function
- you click ok
- And all it asks for is in what cell is the text that you want changed, you click in that cell
- And you say ok
- And you’ll see now that all the capitals have been removed, and your cell immediately looks a bit cleaner.
If you want the cell to become all capitals, you can use the UPPER function. In that case
- You click on a cell
- you activate the Function Wizard
- go to the Text category
- and if you go down
- you go to the UPPER function
- click ok
- and exactly the same way, you click on the cell that contains the text
- and you say ok
- And now your entire cell will be in capitals.
If you want a text of a cell to come through with the first letter in upper case, and the remaining letters of the word in lower case, you can use the PROPER function. To activate it
- you click on the cell
- activate the Function Wizard
- In the Text category
- you find the PROPER function
- you click ok
- you click over there
- and you tell it what cell it must look at
- and when you click ok
- you’ll see that the text comes through with a capital at the beginning of each word, and lower case after that.