| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert to upper case - entire column ?
I have a column of names and would like to do a data conversion
from lower case to upper case. I know the formula is =upper(" ") but is there a way to have it do the conversion for an entire column at once. Don't know what I am doing wrong but it seems I have to enter it in each cell which is not exactly a time saver...... Any suggestions? Thanks. Alicia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a column of text to upper and lower case? | Excel Discussion (Misc queries) | |||
| Change entire column in spreadsheet from upper case | Excel Discussion (Misc queries) | |||
| excel'03 how to convert a column from upper case to proper case | Excel Discussion (Misc queries) | |||
| How to convert entire excel document from lower to upper case | Excel Worksheet Functions | |||
| How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
Threaded Mode
