View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T. Alksndr rstrpo Prado T. Alksndr rstrpo Prado is offline
external usenet poster
 
Posts: 2
Default comma s separator text file

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