Remove apostrophe

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" <glass_patrick@hotmail.com> wrote in message
news:ulY5#hutFHA.2072@TK2MSFTNGP14.phx.gbl...
> 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" <glass_patrick@hotmail.com> wrote in message
news:ulY5%23hutFHA.2072@TK2MSFTNGP14.phx.gbl...
> Where apostrophes ( ' ) appears in a string can it be removed with a
> formula?
>
>
>