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!!