View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pandd15 pandd15 is offline
external usenet poster
 
Posts: 7
Default Adding multiple numbers in one cell

My spreadsheet contains multiple numbers in one cell they are all seperated
by a coma. Is there a formula that will add these numbers?

87563, 8930, 98279 are in one cell I'd like to have the total in another
colum, the total of numbers not the sum, e.g. 3

Thanks,