Transcripts for the above video clip:

LOWER, UPPER and PROPER

 The LOWER, UPPER and PROPER functions in Excel allow you to easily address the capitalisation of text in a cell. 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 segment you will learn how to find, activate and use these functions.

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.