View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Stad Steve Stad is offline
external usenet poster
 
Posts: 14
Default Parse at the first numeric value

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