| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to extract certain text from text string
I'm trying to figure out how to construct a formula to extract certain
information. The text may look like one of the following: Safeway Store # 711 - Mill Valley, CA Jake's Marketplace - Oakland, CA I am wanting to take the city portion (between the "- " and the "," and put it in another column. The number of characters will vary and I'm not sure how to do this. Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract text from string | Excel Worksheet Functions | |||
| Extract text from a string | Excel Worksheet Functions | |||
| Extract text string using MID | Excel Worksheet Functions | |||
| EXTRACT TEXT FROM TEXT STRING | Excel Worksheet Functions | |||
| Extract % from text string | Excel Worksheet Functions | |||
Threaded Mode
