how to change existing column to capital letters
Roger: Thank you for your assistance. I tried your suggestion, but all it
did was copy the 1st name down the entire column. Did I do something wrong?
I tried your suggestion numerous times to eliminate any errors on my part,
but i kept getting the same results. Pls. reply.
thanks in advance!!
fredg
"Roger Govier" wrote:
Hi Fred
Assuming data is in column A, then in an empty column enter
=UPPER(A1)
Copy down new column for the extent of data in column A.
Copy new column and Paste SpecialValues back over column A.
Delete new column.
--
Regards
Roger Govier
"fredg" wrote in message
...
current column is mixed upper and lower case names. I want the entire
column
to be capital letters.
|