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
Bookmarks