Looking for formula to extract characters after the last instance of a specific character.
Formula works but does not correctly pull this instance 1999 - 286082102 - Electronics For Imaging, Inc. - Gassee, Jean-Louis. See the two examples below.
Desired Outcome = Johnson, William P.
=TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",LEN(A2))),LEN(A2)))
1999 - 189873102 - Coachmen Industries, Inc. - Johnson, William P.
Formula does not work for this:
Outcome:Louis
Desired Outcome = Gassee, Jean-Louis
=TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",LEN(A2))),LEN(A2)))
1999 - 286082102 - Electronics For Imaging, Inc. - Gassee, Jean-Louis
Thanks
Bookmarks