Please describe the exact things you're doing after you open the file and
the import wizard appears.



"naulerich" wrote in message
...
I did remove the double quotes and added a ~ instead of the commas, I am
still not getting the output in the correct columns when using the import
with delimiter set to ~....I don't know what to do next...

"Dave Peterson" wrote:

I don't see the double quotes. I don't see the commas between fields.

But if each of those paragraphs is actually a line in a text file, I
could
import the data using delimited by tilde (~) and got different fields.

naulerich wrote:

Here is a sample of the data, thanks so much!

5493~ BASE-(Claims) Auto Format Update I~ Today most of our sites are
utilizing the WEBMD_NSF Format. To ensure that all sites are prepared
for
MSP, electronic secondary, and using the latest claims submission
formats we
must prep for migrating sites to the latest 4E format. This requirement
is in
sync with the EDI requirement with the same name. This is a multi-step
project.~ Today most of our sites are utilizing the WEBMD_NSF Format.
To
ensure that all sites are prepared for MSP, electronic secondary, and
using
the latest claims submission formats we must prep for migrating sites
to the
latest 4E format. This requirement is in sync with the EDI requirement
with
the same name. This is a multi-step project.~ <<internal source
group~ Have
to Have~ ~

5501~ BASE_Patient/Account Alert in Check-in~ Patient Alerts do not
currently work in Patient Check-in. So unless the front desk brings up
the
detail on the patient, alerts are not presented to the user causing
them to
miss critical items at the first contact with the patient.

By presenting this alert when the patient is chosen on the check in
list,
the user will make or take the proper action necessary based on the
alert
message.~ Need to activate Patient and Account Alert during patient
check-in.
Not currently working in Patient Check-in.~ <<internal source group~
Nice
to Have~ ~

"Dave Peterson" wrote:

I think you should copy a few of the lines from the text file into
your followup
post--if you don't get it working.



naulerich wrote:

I am using 2003 it is not respecting the ""...I am going to have
the souce
data delimiter changes to a ~ and see if that helps.

Thanks!

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson