View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amber
 
Posts: n/a
Default Separating text and data in a column

I have a column that contains text and data, never in the same cells, but I
want to separate the numbers from the text in order to do a total at the
bottom. Is there a formula for this?