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

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