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

This cell should now say ABC.

Once this is done select A2,

Copy it

Then right click on cell A1

Select Paste Special

Then values

Then OK

The text will now be uppercase.
