ChAnGe CaSe

When it come to excel one option named change case which we use in MS WORD not present. It became difficult to change the type the whole data again but with the help of change case we can capitalize, lower or write the word in sentence case. To do the work of change case in excel there are some formulas.

• First formula is related to capitalize each word. If we made our data in small alphabets and now we need each word in capital letter .In this data you can each word in lower case.

• By applying formula =UPPER(Select Cell ) . Then press Enter . This is the easy and quick way to convert words from lower to upper.

• Now drag the cell up to the point our name are mention 

• Next formula is to convert the data in sentence case where the first letter of the name will be capital. Formula is =PROPER(Select Range ) . Then Press Enter . 

• And our last case is when our letters are in capital word or sentence case and we want each word in lower case formula to convert in the lower case =LOWER(Select Cell ). Then press Enter 

There is only one exception with this formula you have to apply it in every row or column separately.

If you apply the formula in one column then you can make capital , small words of that particular column.