View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
FM FM is offline
external usenet poster
 
Posts: 1
Default ignoring text data in a cell when summing values in the same cell

I have entered text in cells along with a numerical value as a note pertainig
to the values example, "2 - exist". Is there a way to tell Excell to ignore
the text data in order to sum the values..do you place the text in brackets
or parathesis or something similar?
--
FM