![]() |
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