VBA Split text with multiple conditions

[jjin]

Hi guys, I have a column with a various structure of text and I am trying to use VBA to split the text into number of other columns.

I have attached a sample workbook below it clearly show what I am trying to achieve here.

Any suggestions?

[ikboy]

try this:

Please Login or Register  to view this content.

[jjin]

ikboy, It works perfectly well. You are a legend. thanks.