How to Convert Excel Cell to Uppercase


To convert an excel cell to uppercase, If your text is in A1 Go to A2 and type in “=upper(A1)”;

type in “=uper(A1)”

This cell should now say ABC.

Cell should now say ABC

Once this is done select A2,

Select A2

Copy it

Copy A2 by right clicking

Then right click on cell A1

right click on A1

Select Paste Special

Select Paste Special...

Then values

Choose ‘values’

Then OK

Click the OK button

The text will now be uppercase.

The text will now appear to be uppercase