View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default Function to extract numbers from an alphanumeric cell

There may be many ways to do this, but more info would help:

Are the numbers all together or intermixed with alphas? Are they all at the
beginning of the string, at the end, or in the middle. Are the strings of
consistent length?


"diana" wrote:

Is there a function that will read the numbers only of an alphanumeric cell:
Cell that contains a word and number.
Appreciate anybody's help in this respect.