Create a formula to remove last two characters from a cell if the 2nd character is a space

Hello, I am working with a data set of over 6,000 rows and am looking for a way to reduce some of the extra unique lines.
For Example: Some of the lines are exactly the same but end with a " A" or " B" or " 1" or " 2" ect
Not all lines end with those characters they are just to indicate the same Name has been used multiple times.

Cat
Black Dog
Dog 1
Cat A
Frog
Cat 2
Cat 3
Fish
Black Dog A
Brown Dog
Brown Dog C

Is there a formula that will remove that last two characters if and only the 2nd to last character is a space.
Thanks,
Kevin

Or this

Formula:

Please Login or Register  to view this content.