How to use the Excel Lower Upper case functions. We also show how to use the Proper Case formula.
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
If you want the cell to become all capitals, you can use the UPPER function. In that case
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
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
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