Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change a column of cells to all capital letters?
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 |
#2
|
|||
|
|||
-- 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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Check out
http://www.mvps.org/dmcritchie/excel/proper.htm#upper In article , "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. |
#5
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I change the style in column (a) a date, it also changes colu | Excel Discussion (Misc queries) | |||
How do I change column (A) to say First Name? | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
How to change the width on individual cells | Excel Worksheet Functions |