Patty,

In B1, =UPPER(A1)

Copy B1 down, then copy and Editpastespecial values in column B and delete
column A

--

HTH

RP
(remove nothere from the email address if mailing direct)


"morpattyjo" wrote in message
...
In an Excel workbook thousands of rows long, I need to change an entire
column from small letters to caps. Is there a way to do this without
doing
each individual row?

I'd appreciate any help you can give me.

Thanks, Patty