View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Smith Robert Smith is offline
external usenet poster
 
Posts: 8
Default Breaking out data in a cell

Hi folks,

I download a lot of stats via web queries. One set of stats includes 100 or
so cells in a single column with random data like "74th of 9354" without the
quotes. Can someone help me with a formula to break out the separate numbers
74 & 9354 in the columns to the right, so that I can average those 100 or so
cells?

Thanks for any help you can provide.

Bob