Remove apostrophe

[Pat]

Where apostrophes ( ' ) appears in a string can it be removed with a
formula?

 

[CLR]

=SUBSTITUTE(A1,"'"," ")
This will replace the apostrople's in A1 with spaces.........

Vaya con Dios,
Chuck, CABGx3

 

[Ragdyer]

You do realize that you will have a formula that returns a string, and not
the actual string itself.

As an option, you might think about using <Edit> <Replace> instead, where
there is no formula to be eliminated, if that might become necessary.