Copying Excel data to a .txt file

  • Thread starter Thread starter michalis
  • Start date Start date
M

michalis

Hi,

I am trying to copy an excel file to a .txt ! My excel file has o
column and in each cell there are allot of data seperated by "," (eg
34555,aaa,r34rr, .....). When I try to transfer the excel info to
txt file my data are stored in the txt with quotation marks.

Is there a way to transfer my .xls data to the .txt file without th
quotation marks?

Thank
 
Why don't you just do a search and replace in the .TXT file? You ca
replace the quotation mark with an empty string and all the quotes wil
be removed for you.

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



Rolli
 
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.
 
Back
Top