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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I remove the text qualifier (') from my data in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/116679-how-do-i-remove-text-qualifier-my-data-excel.html)

Robert HAI

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

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?

All times are GMT +1. The time now is 02:59 PM.