in a column if cells have number and alphabets together eg
123abc
abc123
ab134
a12

is it possible to seperate number from alphabets

Thanks for your help

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.