So here is my dilemma and it is driving me nuts.
Starting Cell possibilities:
"FM. Porter Jr. INACT "
"FM. Porter Jr. GTD "
"FM. Porter Jr. OUT "
Desired Output:
"M. Porter Jr."
There is a space before and after "INACT"/"GTD"/"OUT". Some have "Jr." or "III" or nothing after the name. My...