Hi

I am trying to include letters w/ number in a cell and still have Excel add up the column.

For example column might look like this:
1
2
1 AHV (in same cell)
1
1 CHV (ditto)

but when I add the letters to the cell, Excel stops recognizing the number and doesn't include it in the count:
1
2
1 AHV
1
1 CHV
_____
4 (The correct answer should be 6)

Thanks for your help.

Rebecca