Need to extract certain text from text string
With your data in A1, try this formula:
=MID(A1,FIND("-",A1)+1,FIND(",",A1)-FIND("-",A1)-1)
Copy down as required.
Hope this helps.
Pete
On Nov 21, 6:45 pm, Trista @ Pacific <Trista @
wrote:
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.
|