I must be a complete idiot, because I still couldn't get it to work.

Bummer.

"Chip Pearson" wrote:

In a column next to your data, enter the formula

=UPPER(A1)

where A1 is the first cell of your data, and then copy down as
far as you need to go. Then copy this result column and paste
special values over your original data.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Carrie" wrote in message
...
I'm trying to convert data (a list of names) in a single column
to all caps.
I've tried copying and pasting the text from Word, but the data
doesn't
change.

I can't get the instructions in Excel help to fix it either....

ARG!!!!