Losing fields after CSV conversion

[David Rivera]

I am converting an excel file to CSV. I have 65 rows of data, with ~ 7 rows
that contain data from column A to J. For the remaining rows of data I do not
have data in columns B to J however I still need to export commas for all
columns. For the next 6 rows I have commas for each column however the
remaining data in the file converted file only shows commas up to column D.

 

[Dave Peterson]

Try putting something in those empty cells.

I like to use a formula that makes the cell look blank:
=""

 

[Jim Rech]

This is a known Excel issue.

http://support.microsoft.com/kb/77295

If the solution in the article is not viable I think you'd have to use a
macro to create the CSV file.

--
Jim
|I am converting an excel file to CSV. I have 65 rows of data, with ~ 7 rows
| that contain data from column A to J. For the remaining rows of data I do
not
| have data in columns B to J however I still need to export commas for all
| columns. For the next 6 rows I have commas for each column however the
| remaining data in the file converted file only shows commas up to column
D.

 

[Jim Rech]

This is fixed in Excel 2007.

--
Jim
| This is a known Excel issue.
|
| http://support.microsoft.com/kb/77295
|
| If the solution in the article is not viable I think you'd have to use a
| macro to create the CSV file.
|
| --
| Jim
| ||I am converting an excel file to CSV. I have 65 rows of data, with ~ 7
rows
|| that contain data from column A to J. For the remaining rows of data I do
| not
|| have data in columns B to J however I still need to export commas for all
|| columns. For the next 6 rows I have commas for each column however the
|| remaining data in the file converted file only shows commas up to column
| D.
|
|

 

[David Rivera]

Thank you both Jim and Dave. Dave's solution worked and the information Jim
followed up with was very informative and answered why this was happening.

Thank you,

Dave