Daddylonglegs,

Thanks your formula worked.

"daddylonglegs" wrote:

assuming the number is at the end as per your example

=LOOKUP(9.999999999999E+307,RIGHT(A1,ROW(INDIRECT( "1:"&LEN(A1))))+0)

"Ron Rosenfeld" wrote:

On Wed, 21 Feb 2007 12:57:03 -0800, Steve Stad
wrote:

I have a list with a variable text string followed by a numeric quantity. I
would like to parse the numeric quantity into a separate field is there a
function/procedure to find and parse at the first numeric value in a string.
e.g.
Red apples 10
Fresh Florida oranges 9
Southern California tomatoes 19
Iowa potatoes 4
pears 12


=MID(A10,MATCH(TRUE,ISNUMBER(-MID(A10,ROW(INDIRECT("1:"&LEN(A10))),1)),0),255)

entered as an array formula with <ctrl<shift<enter
--ron