ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   comma s separator text file (https://www.excelbanter.com/excel-programming/277099-comma-s-separator-text-file.html)

T. Alksndr rstrpo Prado

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



All times are GMT +1. The time now is 11:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com