current column is mixed upper and lower case names. I want the entire column
to be capital letters.

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.

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.

Hi

It sounds as though ToolsOptionsCalculation is set to Manual.
Select Automatic instead and it should work fine.

--
Regards

Roger Govier


"fredg" wrote in message
...
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.