Remove ' if not followed by two digits
Tom,
For a value in cell A1:
=IF(ISERROR(VALUE(MID(A1,FIND("'",A1)+1,2))),TRIM( SUBSTITUTE(A1,"'","")),A1)
HTH,
Bernie
MS Excel MVP
"tom" wrote in message
oups.com...
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
|