I am using Excel 2013. In Column A I have both numeric and names. For eg.

203010010005-ABDULLAH NASSER

The numbers are codes and words are names.

The length of number differs from 9 to 13 and followed by hypen "-" and without space and the name starts. The length of name is very long

The number sometimes contain alpha numeric also. I would like to separate the codes and names separately.

Can anyone help me in this?

Thanks for your help in advance.

Vatsan