View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robert HAI Robert HAI is offline
external usenet poster
 
Posts: 1
Default 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?