HI ALL
IN CELL A1 I HAVE 1
IN CELL A2 I HAVE H2
IN CELL A3 I HAVE D2
IN CELL A4 I HAVE 2
I would like to sum the entire range but only the numbers not the letters
THE SUM SHOULD BE 7
p.s. there is not space between the h or d to the number
IN CELL A1 I HAVE 1
IN CELL A2 I HAVE H2
IN CELL A3 I HAVE D2
IN CELL A4 I HAVE 2
I would like to sum the entire range but only the numbers not the letters
THE SUM SHOULD BE 7
p.s. there is not space between the h or d to the number