I've unsuccessfully searched, so now I must ask...
Using a formula, how do I pull the exact name of a person from the middle of a text cell, since the length of each person's name varies in the original text cells, and the name within each text cell is not always preceded by (Ghost) but is always succeeded by “ (number)”. e.g., resolve to "Jarman, John" from text cell containing "(Ghost) Jarman, John (21)", or resolve to "Joe Smith" from "Joe Smith (2)"?
Additional Example: Column A needs to be converted to Column B:
(Ghost) Jarman, John (21)
Smith, Joe (2)
Johnson, Harvey (30)
(Ghost) Bob Jolly (-1)
My thanks in advance...