Thank you Norman and Mike, both methods worked great. I appreciate both
responses.

"Norman Jones" wrote:

Hi Alex.

As Mike has introduced the possibility
of a non VBA approach, see:


Extracting numbers from alphanumeric strings
http://office.microsoft.com/en-us/ex...549011033.aspx


---
Regards.
Norman


"Alex" wrote in message
...
There are two parts I am trying to accomplish for a set of data I have in
column A.

What I have Results I would like
A1:kkdd55dd B1:55
A2:eaa5788ee B2:5788
A3:sfse B3:455
A4:
A5:
A6:455dae

If possible I wanted to have a function where it would Search at a range
from A1:A10 and place the first set of numbers it found (always be
together)
in B1, the second set of numbers it finds placed in B2 and so on. As a
reminder I cannot download any type of files if that is to be suggested.

-thank you