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.

Time for the OP to return and tell us worked or didn't work for him.

"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?

Doug Kanter wrote:

In Excel 2000, it doesn't "respect" the commas. The OP has text strings
with
commas within them. Excel interprets them as delimiters, regardless of
the
quotes.

"Dave Peterson" wrote in message
...
When you do File|Open, you should be able to specify Delimited (by a
comma).
Excel will respect those strings within double quotes.



naulerich wrote:

I have a .txt file that looks like:

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

I want my output in excel to be the following:

A1=123
B1=test text
C1=this is a test
D1=abc

Potential problem is that there are commas through out the "test text"
and
"this is a test" columns therefore text to columns wont work. However
what I
need to show in each separate column is enclosed in quotes.

Any help would be appreciated!

--

Dave Peterson

--

Dave Peterson