Adding Cells that Contain Text
This would work, as long as there's a space between the value on the left and
the hyphen:
=VALUE(LEFT(A1,FIND(" ",A1,1)))+VALUE(LEFT(A2,FIND(" ",A2,1)))
--
Kevin Backmann
" 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
|