Take out / ' / this character from a cell

[sc0tt]

My PHP goes nuts when it has this character / ' / and re translates it as;

this; &#39

so any word that&#39s got the character gets this instead; / &#39 /

How can I trim this character out of my text cell if it's got it in there?

[shg]

Maybe = substitute (A1, "'", "").

If that's not it, would you either rephrase or explain your question?

[sc0tt]

Thats exactly what Im talken about!