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



"Pat" <[email protected]> wrote in message
news:ulY5#[email protected]...
> Where apostrophes ( ' ) appears in a string can it be removed with a
> formula?
>
>
>

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pat" <[email protected]> wrote in message
news:ulY5%[email protected]...
> Where apostrophes ( ' ) appears in a string can it be removed with a
> formula?
>
>
>