How do I change a column of cells to all capital letters?

[morpattyjo]

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

 

[Bob Phillips]

--

HTH

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

 

[Bob Phillips]

Patty,

In B1, =UPPER(A1)

Copy B1 down, then copy and Edit>pastespecial values in column B and delete
column A

--

HTH

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

 

[JE McGimpsey]

Check out

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

 

[snn]

=upper(a1)
Then copy the above back to the column.
=lower(a1) for upper case to lower.