13- 17 May, 2013

# Excel lower upper case

How to use the Excel Lower Upper case functions. We also show how to use the Proper Case formula.

• 2:31
• Skill Level:
• 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.

## Separating Lines within a cell

If I understand the query below correctly, the one idea is to type some words in a cell, and then, while holding the ALT key down, click ENTER. Within the cell you will get another line. Hope this helps. Original query Hi, … Continue reading

## Share and Unshare workbooks

A recent email query asked how to share and unshare workbooks in Microsoft Excel with a specific focus on switching off the sharing. The method to share and ‘unshare’ the workbook is the same. As shown in the image below, … Continue reading

AuditExcel (aka Miricle Solutions) provided the Sasol Chlor Vinyls financial team with professional excel training whilst fully understanding the accounting landscape which is highly recommend.

– Sasol Polymers

## View Entire Video Gallery ››

• 03:14
• Skill Level:
• What's my skill level

• 00:42
• Skill Level:
• What's my skill level

## Waterfall chart using stock charts

• 07:11
• Skill Level:
• What's my skill level

## Absolute and Relative cell references

• 06:34
• Skill Level:
• What's my skill level