Monday 22 February 2016

Changing Cases in Excel

A very small post explaining some simple text functions for manipulating text cases in excel. You may have received raw data in a case which you would like to change so that it looks better to eyes.

There are three formulas which you can use for this purpose:

1. =UPPER()
Changes the whole text to upper case.

2. =LOWER()
Changes the whole text to lowencase.

3. =PROPER()
Changes the first letter of all the words to upper case and the rest to lower case.

The syntax of all the three formula is simple: Enter the cell containing the text that you want to change in the brackets.

The screen shot below shows the use of the three formulas:


No comments:

Post a Comment