| 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 |
| 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 | |||
Threaded Mode
