I am trying to import general formatted text from a Microsoft Wordpad .txt
file into Excel 2007. The data is delimited by a space, continuous
delimiters are selected to be treated as one, and my text qualifier is ".

The import wizard preview, as well as the final import into excel, does not
recognize " as a text qualifier, and puts text contained within text
qualifiers in separate cells if separated by a delimiter within text
qualifiers.

For example:
..txt file:
€œVelocity at Muzzle€� €œEnergy at Muzzle€� Trajectory
€œIn yards€� 100 200 300 400 500 100 200 300 400 500 100 300 400 500

Imported data:
Cell A1: "Velocity
Cell B1: at
Cell C1: Muzzle"

What do I need to do to make this import work?

TIA

Following might be the source of your problem;
- Your text begins with €œ (CODE 147) and ends with €� (CODE 148) whereas you
should use " (CODE 34) at both ends... This might be due to pasting in your
post..

- First row has Trajectory at the end without any quotes... remove that or
put it within quotes and test.

"slusby" wrote:

I am trying to import general formatted text from a Microsoft Wordpad .txt
file into Excel 2007. The data is delimited by a space, continuous
delimiters are selected to be treated as one, and my text qualifier is ".

The import wizard preview, as well as the final import into excel, does not
recognize " as a text qualifier, and puts text contained within text
qualifiers in separate cells if separated by a delimiter within text
qualifiers.

For example:
.txt file:
€œVelocity at Muzzle€� €œEnergy at Muzzle€� Trajectory
€œIn yards€� 100 200 300 400 500 100 200 300 400 500 100 300 400 500

Imported data:
Cell A1: "Velocity
Cell B1: at
Cell C1: Muzzle"

What do I need to do to make this import work?

TIA