This would subtract the contents of the cell where you entered the first
formula.
Makes the second formula a little shorter.<g

=SUBSTITUTE(A2,B2,"")
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"RagDyeR" wrote in message
...
This will return *only* the *first* contiguous set of numbers (*no* parens).

=LOOKUP(99^99,--MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A2&"012345 6789")),ROW(INDIRECT("1:"&LEN(A2)))))

This subtracts that *first* set of numbers, and returns what's left over:

=SUBSTITUTE(A2,LOOKUP(99^99,--MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A2&"012345 6789")),ROW(INDIRECT("1:"&LEN(A2))))),"")

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Jamie" wrote in message
...
I need a formula to pull only numbers and one to pull oinly letters from a
cell and put them in another cell.
Scenario:
Worksheet A, Cell A2= (7) apples
I want: Worksheet B, Cell B2 to = (7)
Worksheet B, Cell B3 to = apples