View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Extracting text from a cell

Try using Text to Colums under the Data menu. Use Delimited. Choose other
for Delimiters and type "-".

HTH,
Paul

"kfowlow" wrote in message
...
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.