Thread: Suming Cells that contain text data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wayne Wayne is offline
external usenet poster
  
Posts: 133
Default Suming Cells that contain text data
I need to know if I can sum cells that contain numbers and text in a cell IE
2C + 4T. I want to ignor the text part of the cell data and sum the numbers.

Thanks
Reply With QuoteReply With Quote