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

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing text with text qualifier 2
How do I change text qualifier from double quote? 1
How do I remove text qualifiers from imported data? 0
setting text qualifier in Excel 1
Save delimited format, specify delimiter, remove quotes from text 2
Remove of ' 6
Using the Text Qualifier in the Import Wizard 10
Saving as Text (tab delimited) surrounds text with "quotes" 2

Top