View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Aukerman David Aukerman is offline
external usenet poster
 
Posts: 1
Default Excel 2003, SUM left-most characters

I have a range of cells with these (and only these) possible values:

"1 Completely Inadequate"
"2"
"3"
"4"
"5 Completely Adequate"

Is there a way for me to SUM the values of these cells, including the 1s and
5s which include extra text? Thanks!