I’m looking for the formula to help me pull string values out of a cell, based on certain characters. For example:
If A1 has the string “Mr. Jones – Managing director”
I’d like to pull out “Mr. Jones” and “Managing Director” into separate cells. I know it’s some combination of text functions, but can’t seem to get the right mix. Can you help?
thanks,
Craig
