Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separate name and numbers
I have a column with names and number(s) in them and want to end up with the
name in one column and the number(s) in another column. The first names may actually be just one name or it could include middle and/or title. The number may be 1 or more numbers (these are page number(s) for this name). Here are a few examples: S. J. 45, 46, 59, 71, 138, 139 S. J., Mrs. 138 Samuel J. 51 Sally 3 W. 41 Warren 17, 61, 71, 95, 109 I want 2 columns: Name Page S. J. 45, 46, 59, 71, 138, 139 Samuel J. 51 Sally 3 W. 41 Warren 17, 61 71, 95, 109 Can this be done? thanks in advance if you can help, Sherry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add numbers from separate worksheets | Excel Discussion (Misc queries) | |||
How do I separate numbers? | Excel Discussion (Misc queries) | |||
separate numbers out of string | Excel Worksheet Functions | |||
How to separate numbers from text?? | Excel Discussion (Misc queries) | |||
separate numbers that have a / between them | Excel Discussion (Misc queries) |