Trimming merge data to their respective columns removing hypens , dash , asterisk and so on

[RAM72]

Hi Guys
See attached file certains columns have data merged in one cell . I need to trim data to their respective columns , however some columns have some garbage like *CHN OR BEL' infront. Expected results are in blue to the right of sheet .

Very tedious need to trim up 4000 lines .a pure head ache .

Need formula to trim these data

Thanking in advance for your kind help

 

[Luke M]

Hi Ram,

Take a look at attached, where columns H:Q generate expected results via formulas.

 

[RAM72]

Hi Ram,

Take a look at attached, where columns H:Q generate expected results via formulas.

Thank you for your admirable great Luke.

Now i can do this with much rapidly