Hi,

I have a huge excel file (about 2000+ rows x 28 columns). Column A
contains two types of values - one is all numbers - like: 74925256, the
other type starts with an alphabet: like DW41724AB-ZR2H. Is there a way
I can 'split' this worksheet into two new worksheets on the same file,
so that one of the new sheets contains ALL the data for column entries
with the numerical values, and the other contains all the rows for
column entries beginning with the alphabets?

Thanks,

Joe.