How do I remove the text qualifier (') from my data in Excel?

[Robert HAI]

I need to remove the text data qualifier that preceeds any data string in a
text box. That's the (') symbol. It is coming across to my other application
when exporting.

How do I remove it? Is there a function to strip it off?