| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract text in middle using Mid and Find or Search
Hi,
Here's the string I need to extract from: Regional Sales: SMITH, E. (330146) Here's what I want to end up with: SMITH All the rows contain the same beginning (Regional Sales: ) (:space), it's the length of the last name that varies, but all of the last names end with a comma. I've been spinning my wheels, I know I'm close, but I just can't get it. TIA :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to extract text from middle of a string | Excel Worksheet Functions | |||
| search or find, and extract? | Excel Discussion (Misc queries) | |||
| Extract Middle Initial from Name | Excel Worksheet Functions | |||
| Extract middle initial | Excel Discussion (Misc queries) | |||
| Search/Extract Data w/in Text File | Excel Discussion (Misc queries) | |||
Threaded Mode
