hi

Need to split data in excel macro or vb .

2009DECUK001 DBMSUK01K9001 Photo-Me International PLC Unit 2 Albert Cr N/A Bristol Avon BS2 0SU South West Office & Administration - - Photographic Equipment & Supplies - Mnfrs 3340 0117-971 6849 Mr Norman Acford Manager


need to split in this format in separate cell in ROW .

2009DECUK001
DBMSUK01K9001
Photo-Me International PLC
Unit 2 Albert Cr
N/A
N/A
Bristol
Avon
BS2 0SU
South West
Office & Administration
-
-
Photographic Equipment & Supplies - Mnfrs
3340
0117-971 6849
Mr
Norman
Acford
Manager