Trimming characters to the left ot right of a common word/symbol/phrase.. con't.. ?

Hi , some members were nice enough to help out with a formula to trim characters off of the left side of a common word.

=TRIM(RIGHT(A1,LEN(A1)-FIND(" -in- ",A1)-5))

e.g.

common characters are "-in-"

Mary -in- Ohio
Robert -in- Nebraska
Bob -in Texas

BUT.. now I need to trim to the right of the common characters for a different task. I can't figure out how to invert the formula. Any help would be mega appreciated . thanks