seprating words from numbers

A

Ankur

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
 
D

Dave O

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.
 
Top