Extracting text from a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the easiest way to extract the text between the " - " in this cell

Churchill County - Cottonwood Canyon - Geology

I can start the pull out oaky from the left, but how do I go to the " - " on
the right? It seems easy but haven't found the right function or a group of
functions yet.

Thanks for the help in advance.
 
This is in several cells to make it easier to follow. You can combine it
into one cell if you like:

in A1:
Churchill County - Cottonwood Canyon - Geology
in A2:
=FIND("-",A1,1)+2 where center text starts
in A3:
=FIND("-",A1,A2)-1 where center text ends
in A4
=MID(A1,A2,A3-A2)

The trick is finding the second "-" by starting after the first one!!
 
Try using Text to Colums under the Data menu. Use Delimited. Choose other
for Delimiters and type "-".

HTH,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extract text between 2 tags 2
extract word before / 3
Extracting text separated by | from string? 3
Extract Month From A Text String 4
Extract specific information from the body of outlook mail to an Excel File using VBA 0
extracting text from cells 11
How to extract zip code from a 1 cell adress line? 2
CONVERT TEXT 2 NUMBERS 6

Back
Top