|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 14th, 2006, 09:33 PM
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
March 14th, 2006, 09:46 PM
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
March 14th, 2006, 09:54 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need macro to delete all text cells in an Excel range | GVT | Worksheet Functions | 2 | February 26th, 2006 12:25 PM |
| Concatenating info from several cells into the one above | method373 | General Discussion | 1 | February 22nd, 2006 01:18 AM |
| Easiest way to delete blank cells in column (not entire row) | sramsey | General Discussion | 4 | February 16th, 2006 04:28 PM |
| How to partially lock the cells in Excel? | Locking cels in Excel | General Discussion | 1 | September 19th, 2005 02:21 PM |
| Select Query By Month. | Terry | Running & Setting Up Queries | 6 | June 2nd, 2005 04:10 PM |
Linear Mode
