SAM2009

asked on

# How to convert entire Excel sheet in uppercase?

How to convert entire Excel sheet in uppercase?

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?

Is that an option?

try this;

=IF(ISNUMBER(Sheet1!A1),Sheet1!A1,UPPER(Sheet1!A1))

=IF(ISNUMBER(Sheet1!A1),Sh

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thank you it works fine!

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