Hi this is Adeel

I am using Excel 2010. I have to separate the data of cells which has alpha and numeric values.

For Example
wqui321
uiqewyr372
ruwei1
d938274
e-5
skldd-5378

I have tried LEFT & RIGHT functions, =ROW(INDIRECT(A1)) and few more. but non worked. I will be great full if anyone can help me out. how can i split the data?