| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change data of entire column from small case to upper case
How do I change the data of an entire column from small case to upper case?
Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change data of entire column from small case to upper case
You can use an adjacent (newly inserted???) column.
Then fill it with formulas like: =upper(a1) Then you can copy this column and paste special|values over the original column. Then delete this helper column. Ann wrote: How do I change the data of an entire column from small case to upper case? Thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert to upper case - entire column ? | Excel Discussion (Misc queries) | |||
| Change entire column in spreadsheet from upper case | Excel Discussion (Misc queries) | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
| HOW DO YOU CHANGE AN ENTIRE SPREAD SHEET FROM LOWER CASE TO UPPER | Excel Discussion (Misc queries) | |||
| How do I change a column in Excel from upper case to lower case? | Excel Worksheet Functions | |||
Linear Mode
