Try this:

=SUMPRODUCT(MID(A1:A2,2,FIND(" ",A1:A2)-1)+0)


" wrote:

Is there anyway that I can add two cells ie.

cell 1 - (5 - Oranges)
cell 2 - (6 - Grapes)

and get a sum of 11 in the third cell...i cant just use the sum
function because of the text being in the cells