Need formula to split long string as per header

[breadwinner]

Dear Experts

I have tried to solve the issue even with key words, i need a formula to consolidate string value from one cell value to multiple cells

for e.g

i have collapse data of name,adddress,DoB,Email,Mobile,Desingation in column A i want split as individual data string into different cell values

Please find the attachment

Regards
ROBIN

[Pepe Le Mokko]

Are you still using XL 2010 ? If you have a more recent version, please update your profile. Answers are tailored to the XL version and recent versions have new functions. Thx

[breadwinner]

im using 2016xl