Hi -

I'd like a quick formula that will remove an apostrophe if the
apostrophe is not followed by two digits. Ex:

Original Desired Result
Abe '89 Abe '89
Bye '88 Bye '88
Chie ' Chie
Lead '64 Lead '64
Foloow ' Foloow

What is the quickest way to do this? I'm struggling with
=LEFT(A2,FIND("'",A2) . . .


Thanks for your help.

-Tom