Macro to remove " around a string of data

[CM03486]

Hello,
I need a macro to remove " marks that are appearing around strings of data. I have a spreadsheet that contains multiple columns of text and when I save the speadsheet as a .txt file some of the strings have " marks around them. The " marks are not visible when the data is viewed in Excel. When the file is opened in Notepad the " marks are visible. I need to get rid of all " marks in the spreadsheet. The " marks are not allowing the .txt file to be imported. Help!!

[Richard Buttrey]

Hi,

You'll need to upload your workbook so that we can see the request in context. Stating the obvious but have you tried using Find and Replace to find a " mark and replace it with a null value?

[porkandbeans]

You don't need macro, just remove using Excel Find/Replace tool

[Pete_UK]

Have you tried doing Find & Replace (Ctrl-H) in Notepad? CTRL-A first to select everything, then CTRL-H:

FIND - type "
REPLACE WITH - leave blank
Click Replace All, then save the file with CTRL-S.

Hope this helps.

Pete