Here are a couple of records:
609753|A|ABBASZADEH|PAYMAN|||2120|||LANSDOWN|DR||| CARROLLTON|75010|||||||||M|1984|06/30/2002|06/30/2002|0200|01|024|009|065|002|014|006|||006||004||| |||||8GEN|E||||||||||||||||||||||||||||||||||||||| ||||||||||||||||||||2GEN|P|||||||||||||||||||||||| ||||||||||||||||||||||||||||||||LAURA|05/27/2008|1090374066|0|Y
719724|S|ABERLE|JAMES|||4255|||LAVACA|TRL|||CARROL LTON|75010|||||||||M|1968|05/21/2005|05/21/2005|0200|01|024|009|065|002|014|006|||006||004||| |||||||||||||||||||||||||||||||||||||||||||||||||| |||||||||||||||||||||||||||||||||||||||||||||||||| ||||||||||||||||||||||VEMACS_PERIODIC|08/20/2009|1090374370|0|Y


Doug



"Dave Peterson" wrote in message
...
There's an option to "treat consecutive delimiters as one" on that text to
columns wizard (step 2 of 3???).

Maybe you can check it or uncheck it (depending on how you want it
treated).

Doug Mc wrote:

I'm trying to import a text file into a blank xls file.
It has delimters of bars (I guess - looks like an l with nothing at the
top
or bottom.)
It works fine if there's only one delimiter but if there are two or more
together I can't get the columns specified.

How do I do that?

Thanks,
Doug

--

Dave Peterson