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

Hi,

You can use the sum function as follows to solve your problem:

=SUM((VALUE(LEFT(A1,1))),VALUE(LEFT(A2,1)))

cell a1 -- 5 - oranges
cell a2 -- 6 - Grapes

so that you will get 11 as result.

Hope this will clear your doubt.

Regards,
Soundar.


" 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

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