I have a spread sheet with company, name and tel columns. I need to convert
the Company column to all caps. ???
use =UPPER(A1) in a helper cell then copy over the originals by pasting
values.
> I have a spread sheet with company, name and tel columns. I need to convert
> the Company column to all caps. ???
daveylee - 21 Nov 2005 23:21 GMT
Thanks... your suggestion worked just fine.
daveylee
> use =UPPER(A1) in a helper cell then copy over the originals by pasting
> values.
>
> > I have a spread sheet with company, name and tel columns. I need to
> convert
> > the Company column to all caps. ???