Help w/ excel data import

[hollarindy]

I need ideas/suggestions to 1. import this data from a text file into a useable format in excel and 2. do it without using a macro.

DOCNBR STOCK NUMBER NOMENCLATURE IC C C UI A-S-C AUTH INUSE CALIB MAINT QNTY CE UNIT PRICE P CODE WM A MEMO FIRM

0001 6695 01 551 5125RN CALIBRATION SET U P B EA 734AAAO 1 1 0 0 0 Y $27200.00 0 0 NF4
EAID LOCATION - BPU - ASL - UTC - ZZZZZZ INCR - ZZZZZZ SRD - ZZZ
PART NUMBER PG7601-SYS-AF ITEM APPL PMEL MANUFACTURERS CODE 2J641
0002 6625 00 891 5939RH CAPACITOR 14 U P B EA 734AABA 1 1 0 0 0 Y $3522.40 0 0 NF4
EAID LOCATION - BPU - ASL - UTC - ZZZZZZ INCR - ZZZZZZ SRD - ZZZ
0003 6625 01 514 3942RH ANALYZER,SPECTR U P B EA 734AABO 1 0 0 0 0 Y $28557.30 0 0 NF4
EAID LOCATION - BPU - ASL - UTC - ZZZZZZ INCR - ZZZZZZ SRD - ZZZ
PART NUMBER PD03WRLEEC154 ITEM APPL ANDREWS/EME MANUFACTURERS CODE 98752

You can see the data has headers, and that there are three seperate records; however when it is imported into exel the cells don't line up right.

 

[venkat1926]

use data(Menu) texttocolumn submenu