Welcome, in this blog you are going to learn basic text formulas. There are certain text formulas where you can you to play a game with text which is written on any excel sheets. Use the single and combination of these functions and improve your excel knowledge. Here you go.

 

Q1. Here we have given a set of data where you have to make the text to Upper, Lower and Proper cases.

Full Name

Upper

Lower

Proper

Vasudevan Vasanthan

 

 

 

Patil Roshani

 

 

 

Rajendran Thamizharasan

 

 

 

Priyadarshini Gayathri

 

 

 

Ramsankar Raghavini

 

 

 

 

You can copy the above table directly to your excel and perform the action.

Solution:

Upper: Generally, you might have know the Upper case. In this case all the alphabets / words are written in CAPITAL letters. So, converting your data to capital letters is very simple using MS Excel.

Fun: One of my managers has given a set of data to my colleague to convert all the text to Upper case. He doesn’t know how to do it, so he sat all day and typed each and every data in Upper case…!! LOL

Hmm, so by using =Upper formula you can convert any text to Upper case.

Formula: =Upper (Text)

In the parenthesis you can provide the cell address which you want to change to Upper case.

Similarly, you can use the following formulas to get lower & proper case which is commonly called as sentence case.

Lower ->  =Lower (Text)

Proper ->  =Proper (Text)

Finally, your must visible as shown below.



Do not try to copy the above one, I know your intelligence that’s why I have shown the data in image format. Also, do not try to convert jpeg to excel. Learn the formula to make wonders in future. Hope you guys like it.

 

If you have any queries on this topic, please do comment and wait for my response within 24 hours. Thanks a lot.