"Doug Kanter" wrote in message
...
"Dave Peterson" wrote in message
...
I don't have xl2k anymore, but that's not the way I remember it working.

I put:

"123","test, text","this is a test","abc"
"123","test, text","this is a test","abc"
"123","test, text","this is a test","abc"

in a text file and xl2003 imported it nicely (test, text was one field).

Can you try it one more time?


Now, that's interesting. The test strings I used were numerical, and
looked like the line below:
"1234,5678,9" Excel broke that into three columns. I wonder if it behaves
differently when the strings in question are numerical.

Interesting, as you say. I found that it kept the 1234,5678,9 together if
the preceding double quote mark is immediately after the comma, but not if
there is a space between.

The first line here keeps the numeric string together, but the second line
splits it:
"123","test, text","this is a test","abc","1234,5678,9"
"123","test, text","this is a test","abc", "1234,5678,9"
--
David Biddulph