comma s separator text file

  • Thread starter T. Alksndr rstrpo Prado
  • Start date
T

T. Alksndr rstrpo Prado

Hi to all
I have this problem I'm working with a text file,
I have a macro who opens the text file, and make some
changes in the file, the the macro saves the file, under
text format, so the problem is this:
In the cell A6 I have this text:
where(substr(text1,1,2))
So when excel saves the changes the cell A6,
is saved like this:
"where(substr(text1,1,2))"
because the commas in the text, I want to save the cell
value in the way it is (with commas), and no with
quotation marks.
I don't want the quotation marks, I try with to saved like
commas separator text file, but it doesn't work either.

I hope you can help me.
Thanks alot
Be good
The force be with you
 

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

Top