Re: $$Excel-Macros$$ about conversion of excel to text file.

2017-02-08 Thread libertystringer via MS EXCEL AND VBA MACROS
On Wed, 2/8/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ about conversion of excel to text file. To: "excel-macros@googlegroups.com" Date: Wednesday, February 8, 2017, 2:13 PM The format .csv is a comma separated fie

Re: $$Excel-Macros$$ about conversion of excel to text file.

2017-02-08 Thread Paul Schreiner
The format .csv is a comma separated field format. (Comma Separated Values) You should be able to use File->Save As->and choose this type. I'm not sure what you're expecting with the "space between all columns and values". If you are expecting a comma AND a space between each column,then you're go

$$Excel-Macros$$ about conversion of excel to text file.

2017-02-07 Thread Pravin Choudhari
I have 10 columns in excel and want to convert into the text file. I tried when saved in the text file it shows a lot of spaces between columns. my requirement is each column and values should be separated by a comma and there should be space between all columns and values. Please help me. --