I need to save an Excel spreadsheet to a delimited text file, (either tab or
comma). The last 2 columns are blank on the spreadsheet. The delimiters
for the blank fields stop showing on the text file after 15 records. I went
back into the 16th row on spreadsheet and typed a space in each of the last 2
columns. When I save that as a delimited text file, the delimiters were at
the end of the records for the 1st 15, the 16th, and the next 15, but then
they stop again. I need those delimiters for those blank fields. Any help
will be greatly appreciated.

I had the same quetion ealier this week and Dave Peterson gave this reply:

"This might describe the problem of too many commas in CSV files:

http://support.microsoft.com/default.aspx?scid=77295
Column Delimiters Missing in Spreadsheet Saved as Text

(It actually describes missing delimiter, but if some are "missing", maybe the
ones appearing are "extra".)

Maybe you can just fill the empty cells with your own placeholders.

I'd use a formula like this:
=""

--

Dave Peterson"

I used the ="" formula and filled it down both empty columns, saved as .csv,
and it work fine.



"BrianFromMN" wrote:

I need to save an Excel spreadsheet to a delimited text file, (either tab or
comma). The last 2 columns are blank on the spreadsheet. The delimiters
for the blank fields stop showing on the text file after 15 records. I went
back into the 16th row on spreadsheet and typed a space in each of the last 2
columns. When I save that as a delimited text file, the delimiters were at
the end of the records for the 1st 15, the 16th, and the next 15, but then
they stop again. I need those delimiters for those blank fields. Any help
will be greatly appreciated.

This describes the problem.

http://support.microsoft.com/default.aspx?scid=77295
Column Delimiters Missing in Spreadsheet Saved as Text

I'd put
=""
in the cells in the last column for all rows to see if that helped.

Or maybe you could write your own exporting program that would behave exactly
the way you want:

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(or maybe you could build your own formula and copy|paste into Notepad.)

BrianFromMN wrote:

I need to save an Excel spreadsheet to a delimited text file, (either tab or
comma). The last 2 columns are blank on the spreadsheet. The delimiters
for the blank fields stop showing on the text file after 15 records. I went
back into the 16th row on spreadsheet and typed a space in each of the last 2
columns. When I save that as a delimited text file, the delimiters were at
the end of the records for the 1st 15, the 16th, and the next 15, but then
they stop again. I need those delimiters for those blank fields. Any help
will be greatly appreciated.

--

Dave Peterson

Hey, that looks familiar!

CoyB wrote:

I had the same quetion ealier this week and Dave Peterson gave this reply:

"This might describe the problem of too many commas in CSV files:

http://support.microsoft.com/default.aspx?scid=77295
Column Delimiters Missing in Spreadsheet Saved as Text

(It actually describes missing delimiter, but if some are "missing", maybe the
ones appearing are "extra".)

Maybe you can just fill the empty cells with your own placeholders.

I'd use a formula like this:
=""

--

Dave Peterson"

I used the ="" formula and filled it down both empty columns, saved as .csv,
and it work fine.

"BrianFromMN" wrote:

I need to save an Excel spreadsheet to a delimited text file, (either tab or
comma). The last 2 columns are blank on the spreadsheet. The delimiters
for the blank fields stop showing on the text file after 15 records. I went
back into the 16th row on spreadsheet and typed a space in each of the last 2
columns. When I save that as a delimited text file, the delimiters were at
the end of the records for the 1st 15, the 16th, and the next 15, but then
they stop again. I need those delimiters for those blank fields. Any help
will be greatly appreciated.

--

Dave Peterson