String search - multiple occurrences

I know I should be able to solve this but I have confused myself greatly. In the attached file I am attempting to extract a part of a string into two(2) columns. The string is defined as a text field and contains two distinct pieces of information separated by a "-". My problem is that some of the strings contain multiple "-" and I need to separate the string based upon the placement of the last (in the case of multiple) "-".

The attached file gives examples of the string, my desired Field 1 and Field 2 and the current results of my formulas. I would prefer to do this outside of VBA. Any assistance, or direction to a good Excel string tutorial, given will be much appreciated.

John Countzler

H jcountzler,

See the attached with the formula you desire.

Appreciate this is Solved by MarvinP but simply to illustrate another approach:

Please Login or Register  to view this content.