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.
|