| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract name before comma, space & number
I have a column of names that also have page number(s). Here are some
examples: Mary, 155 Joe, Rev., 60 Mark, Mrs., 115, 120, 130 There could be many page numbers. I have a working formula for getting the page numbers into a separate column. I can't find one that gets the Joe, Rev. (for example); I only get Joe. Can you help? Thanks if you can!! Sherry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time exported w/ space/comma, Convert to Number | Excel Worksheet Functions | |||
| Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
| add extra space before comma | Excel Worksheet Functions | |||
| Inserting a space after a comma | Excel Worksheet Functions | |||
| Removing a space after a comma | New Users to Excel | |||
Threaded Mode
