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,
Then right click on cell A1
Select Paste Special
The text will now be uppercase.