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!
|