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