Link to home
Start Free TrialLog in
Avatar of SAM2009
SAM2009Flag for Canada

asked on

How to convert entire Excel sheet in uppercase?

How to convert entire Excel sheet in uppercase?
Avatar of Runrigger
Runrigger
Flag of United Kingdom of Great Britain and Northern Ireland image

add another worksheet.

in cell A1, type the following formula - =UPPER(Sheet1!A1)

Then drag the formula out to cover the target data range.

Copy and paste special the formula to values!

assumes;

1) That you only have text values (probably not)
2) The sheet that you want to convert to upper is called Sheet1
that's the quick way (although it will convert numbers to text, which can easily be converted back to numbers using text-columns), the alternative is to have a macro do this for you.

Is that an option?
try this;

=IF(ISNUMBER(Sheet1!A1),Sheet1!A1,UPPER(Sheet1!A1))
ASKER CERTIFIED SOLUTION
Avatar of FernandoFernandes
FernandoFernandes
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SAM2009

ASKER

Thank you it works fine!