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