If the different combinations are grouped- for instance, all the 123abc
types are in one place, all the ab134 types are in another place- you
can use functions such as MID, RIGHT, or LEFT to separate them. (By
"types" I mean the first x columns are numeric characters, and the
following y columns are alpha characters.) If they are mixed and cannot
be grouped then you'd need VBA code to perform the separation.