Split Text with formula

[aanaduta]

Hi all,
I want to split text in multiple rows using formula. In Colomn A is the raw data which I want to split so that I can get only data that I need. Example data I need is in colomn B and C. Can you please help? Thanks Al

[TABLE="width: 480"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]String Text[/TD]
[TD]To be shown[/TD]
[TD]To be shown[/TD]
[/TR]
[TR]
[TD]MC3496 AFC285 [/TD]
[TD]MC3496[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2015 HOLDEN CASCADA CJ MY15.5[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Silver, CONVERTIBLE, Trans: Automatic $34,990[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] $35,745 6 / 12 98% 8,500[/TD]
[TD]6/12[/TD]
[TD="align: right"]98%[/TD]
[/TR]
[TR]
[TD] (5,945) 338[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (192) 18[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (34) 541[/TD]
[TD="align: right"]541[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (7) 77 [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MC4038 1JR3OF [/TD]
[TD]MC4038[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2015 HYUNDAI VELOSTER + FS4 SERIES II[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Orange, HATCHBACK, Trans: Automatic $22,830[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] $23,973 1 / 14 95% 51,872[/TD]
[TD]1/14[/TD]
[TD="align: right"]95%[/TD]
[/TR]
[TR]
[TD] (42,254) 56[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (39) 0[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (0) 143[/TD]
[TD="align: right"]143[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (0) – [/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MC4054 ZXJ720 [/TD]
[TD]MC4054[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2013 FORD FALCON XR6 FG MKII[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Red, SEDAN, Trans: Automatic $19,440[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] $19,732 13 / 22 99% 88,050[/TD]
[TD]13/22[/TD]
[TD="align: right"]99%[/TD]
[/TR]
[TR]
[TD] (72,173) 52[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (85) 0[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (116) 207[/TD]
[TD="align: right"]207[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (4) 52 [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MC4048 YUO881 [/TD]
[TD]MC4048[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2012 MITSUBISHI TRITON GLX-R MN MY12[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Grey, PICKUP, Trans: Automatic $23,940[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] $26,325 1 / 3 91% 133,604[/TD]
[TD]1/3[/TD]
[TD="align: right"]91%[/TD]
[/TR]
[TR]
[TD] (125,531) 52[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (28) 0[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (0) 537[/TD]
[TD="align: right"]537[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] (11) 49 [/TD]
[TD="align: right"]11[/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col span="2"></colgroup>[/TABLE]

 

[AliGW]

There is not enough commonality between what you want to do with each type of data for you to be able to do this with a formula.