Split data in alpha and numeric

[eadee]

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?

[Ace_XL]

Try...in B1

=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0 123456789")),ROW($1:$10000))))

This will give you the numbers..

You could then use

=Left(A1,len(A1)-len(b1))

assuming your values are always in the format "abcd1234" or its variants

[Fotis1991]

Hi

For text, this Array formula(C+S+E)

=LEFT(A1,MATCH(1,ISNUMBER(MID(A1,COLUMN($1:$1),1)*1)*1,0)-1)

For numbers.

=LOOKUP(9^9,1*RIGHT(TRIM(A1),COLUMN($2:$2)))