Parse at the first numeric value
Thanks Ron,
Can you explain what the ROW(INDIRECT("1:"&LEN(A10))),1)),0),255) function
does. I am getting an #N/A when I try the whole formula below. Did you test
it...i.e., does it work for you?
Thanks
Steve
"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
|