Complex text import to excel file

R

Rajputkps

I want to import a complex text file in xls format. can you help me

Text file shows as :

VCODE DOCNO VNAME/NARRATION AMOUNT

101101 MAX TECHNOLOGIES
5500151 Purchase -Keyboard
1000.00
5500152 Purchase-Mouse
2000.00


101102 DIGITECH COMPUTER
5500221 Purchase-SMPS
5000.00
5500222 Purchase-Motherboard
10000.00


After importing text file in excel sheet, data should be shown as

VCODE VNAME DOCNO NARRATION
AMOUNT
101101 MAX TECHNOLOGIES 5500151 Purchase -Keyboard
1000.00
101101 MAX TECHNOLOGIES 5500152 Purchase-Mouse
2000.00
101102 DIGITECH COMPUTER 5500221 Purchase-SMPS
5000.00
101102 DIGITECH COMPUTER 5500222 Purchase-Motherboard
10000.00

You all are requested to please give me guide through VBA macros.
Thanks very much

kps.rajput
[email protected]
 
Top