| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I partially delete info in many cells at once?
I have a mailing list in excel that on one column contains ages but it reads
"AGE: 65" or whatever age is in the cell. I want to map this to a contact manager that has a place for age but only the actual number. Is there a way to delete the "AGE:" and just leave the number so only that number gets imported? There are 4,500 contacts so it woud take me forever to do i t one at a time. Thanks George |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I partially delete info in many cells at once?
You can use the "text to columns" feature (under Data in the toolbar) to
parse the information as long as the column information always has a fixed width. "George Stott" wrote: I have a mailing list in excel that on one column contains ages but it reads "AGE: 65" or whatever age is in the cell. I want to map this to a contact manager that has a place for age but only the actual number. Is there a way to delete the "AGE:" and just leave the number so only that number gets imported? There are 4,500 contacts so it woud take me forever to do i t one at a time. Thanks George |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I partially delete info in many cells at once?
Nevermind, I just saw the "Replace" function.
"George Stott" wrote in message . .. I have a mailing list in excel that on one column contains ages but it reads "AGE: 65" or whatever age is in the cell. I want to map this to a contact manager that has a place for age but only the actual number. Is there a way to delete the "AGE:" and just leave the number so only that number gets imported? There are 4,500 contacts so it woud take me forever to do i t one at a time. Thanks George |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easiest way to delete blank cells in column (not entire row) | Excel Discussion (Misc queries) | |||
| Macro to Delete blank cells | Excel Worksheet Functions | |||
| Excel should allow delete cell's value but leave formula alone. | Excel Discussion (Misc queries) | |||
| Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
| Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
Hybrid Mode
