| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make an entire column Uppercase?
I would like to convert my entire column to uppercase in Excel 97. Is that
possible? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I make an entire column Uppercase?
It's definitely possible. For the sake of example, let's just say that
you're working with column A. In Column B, type =UPPER(A1), then copy it down the column. Then, if you want to keep the original data in Column A, you're done. If not, copy column B, then go to Paste Special and paste only the values over column A. You can delete column B once you do that and you have a perfectly uppercase column. Hope that helps! Jezzica85 "Jack" wrote: I would like to convert my entire column to uppercase in Excel 97. Is that possible? Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I make an entire column Uppercase?
You need a macro to change text constants in place (via a selection)
see Proper, and other Text changes -- Use of SpecialCells Uppercase http://www.mvps.org/dmcritchie/excel/excel.htm#upper --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "jezzica85" wrote in message ... It's definitely possible. For the sake of example, let's just say that you're working with column A. In Column B, type =UPPER(A1), then copy it down the column. Then, if you want to keep the original data in Column A, you're done. If not, copy column B, then go to Paste Special and paste only the values over column A. You can delete column B once you do that and you have a perfectly uppercase column. Hope that helps! Jezzica85 "Jack" wrote: I would like to convert my entire column to uppercase in Excel 97. Is that possible? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make it add a column based on 2 different criteria? | Excel Worksheet Functions | |||
| Making Hyperlinks Active In Entire Column | New Users to Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| a fomula for an entire column | Excel Discussion (Misc queries) | |||
| How do I make an entire column do the same calculation across a r. | Excel Discussion (Misc queries) | |||
Hybrid Mode
