Fredrick

The import wizard will put records on one row.

There is no provision for inserting every n'th record on a new row AFAIK.

Perhaps OP could try the wizard and use both comma delimited and "other" with
ALT + 0010 entered in that box?


Gord Dibben Excel MVP

On Wed, 23 Mar 2005 21:16:41 +0100, "Fredrik Wahlgren"
wrote:


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Achal

After import you could try EditReplace

what: ALT + 0010(or 0013).....use the numpad to enter the 0010

with: nothing

Replace all.



This will remove all carriage returns, right? Won't Excel try to put all the
data in one row? Is there an option in the import wizard that tells excel to
insert every n'th record on a new row?

/Fredrik