Extracting numbers from the right of an alphabetical tring

**deemo** · 12-10-2009, 09:16 AM

Hello,

I have a list of items like this

aas12
aabc2
sw1234

I would like to be able to get 2 resulting columns containing just the string of alphanumerical characters and the numerical characters

aas
aabc
sw

and

12
2
1234

How can I best go about this?

**DonkeyOte** · 12-10-2009, 09:20 AM

If your strings are in A1:A3 then

Please Login or Register  to view this content.

B1:C1 copied down to B1:C3

**deemo** · 12-14-2009, 05:20 AM

Thanks a lot... getting a "True" or "False" as result though. Am I missing an argument?

**DonkeyOte** · 12-14-2009, 05:22 AM

TRUE/FALSE for which formula ?

I can't see how you're getting a Boolean output unless you've used 0=SUBSTITUTE(...) rather than 0+SUBSTITUTE(...)

Care to post a sample file illustrating the issue ?