HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS?

daveylee · Nov 21, 2005

I have a spread sheet with company, name and tel columns. I need to convert
the Company column to all caps. ???

Dave R. · Nov 21, 2005

use =UPPER(A1) in a helper cell then copy over the originals by pasting
values.

daveylee · Nov 21, 2005

Thanks... your suggestion worked just fine.
daveylee