Help w/ excel data import

hollarindy

New Member
Joined
Jun 18, 2012
Messages
1
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.
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,123,385
Messages
5,601,331
Members
414,446
Latest member
CRAVIN

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top