AFAIK there is nothing about Excel's importing feature that provides for
variable random carriage returns. I'm certain that there are a number of VBA
solutions, but I would first try to edit the extra paragraph breaks out using
Word's Find & Replace feature.

HTH |:)

"Achal" wrote:

I am using Excel 2003.
I need to import a comma delimited file into an excel sheet.
While importing into an excel sheet I need to ignore some carriage
returns/newline characters. I tried using double quotes (") but this doesn't
ignore newline charcters.
Sample file is as follows
1,name,description
details
2,name,description details
3,name,description details
In the above I need to ignore the carriage retun of the 1st record and
display the 'description details' in one column.