[B]Why don't you just do a search and replace in the .TXT file?  You can
replace the quotation mark with an empty string and all the quotes will
be removed for you.

The only other way to do this is to use some VBA code and create a
macro to do this.

Hi Rollin.

I have created a macro with VBA code already and the macro is creating
the problem. Maybe I did not make my self clear so I will expain again
whats going on:  I have data in an excel sheet. My macro takes that
data and transfers them into a .txt file. Through the process though,
the data ends up in the .txt file with quotation marks at the beggining
and end (eg: "abcd1234").

I understand what you mean by seach and replace in the .txt file but
the poing is that I want to avoid doing it mannually. Instead I would
like the macro to paste the data without the quotation marks.

I hope that helps and that you have a suggestion.

Thank you,
Michalis

P.S. I already tried (with VBA code) to transfer all data from excel as
'values' but it still does not work.

---
Message posted from http://www.ExcelForum.com/