Importing text with text qualifier

S

slusby

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
 
S

Sheeloo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top