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

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

Vaya con Dios,
Chuck, CABGx3



"Pat" wrote in message
...
Where apostrophes ( ' ) appears in a string can it be removed with a
formula?

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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pat" wrote in message
...
Where apostrophes ( ' ) appears in a string can it be removed with a
formula?