It’s quite easy to convert text to upper case in Word, but how do you do it in Excel?!Suppose your text is in cell C3 which you want in Upper Text.

In Cell C4 (or anywhere where you need your text in Upper Case), write the below extremely simple formula: –
=UPPER(C3)
If C3 has text “i love excel”, in C4 it will appear as “I LOVE EXCEL”.

Done!

Now now want your text in C4 to become text, and not remain as a formula. Confused? Don’t worry, read this post..
Paste As Values / Convert Formula to Result

Keep Excel-ing!