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
Bookmarks