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)


"morpattyjo" <morpattyjo@discussions.microsoft.com> wrote in message
news:B449AD4C-9EF9-47C9-962D-E4F355A0E34E@microsoft.com...
> 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]

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)


"morpattyjo" <morpattyjo@discussions.microsoft.com> wrote in message
news:B449AD4C-9EF9-47C9-962D-E4F355A0E34E@microsoft.com...
> 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

[JE McGimpsey]

Check out

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

In article <B449AD4C-9EF9-47C9-962D-E4F355A0E34E@microsoft.com>,
"morpattyjo" <morpattyjo@discussions.microsoft.com> wrote:

> 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.

[snn]

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

"morpattyjo" wrote:

> 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