I have Input in format of 9:ak-IT-ABC;2:others- -su1; ..... ; in one cell, How to separate these values in excel

I have Input in format of:

9:ak-IT-ABC;2:others- -su1; ..... ; 

in one cell, how to separate these values in excel & write in another sheet?

Input:

9:ak-IT-ABC;2:others- -su1; ..... ;

Output want:

 A    B     C    D
 9    ak    IT   ABC
 2    others     su1

from Recent Questions - Stack Overflow http://ift.tt/29Q2NpD
via https://ifttt.com/ IFTTT