single / double numbers in cells

[youngie]

Hi,

Say i have 1-2 numbers in a single cell going across the page for a varied length. What i would like to do is add the 2 numbers together that is in 1 cell.

e,g

1 2 3 44 5 6
1 2 3 8 5 6

hope this makes sense

Thanks

Josh

 

[Scott Huish]

If the numbers were say 37, do you want 10 or 1?

 

[jammoca]

try this ...

if 37 was typed into cell A1, and you wanted it to add the 3 and the 7 then this should work ...

=LEFT(A1,1)+RIGHT(A1,LEN(A1)-1)

it should work even if there is only a single digit in cell A1

 

[Scott Huish]

If you want 37 to add up to 1 (i.e. 3+7=10, 1+0=1)
=IF(MOD(A1,9),MOD(A1,9),9)

 

[youngie]

Thanks jammoca, however it does not seem to work with single numbers in cells - any ideas?

Thanks

 

[jammoca]

try this ....

=IF(ISERROR(LEFT(A1,1)+RIGHT(A1,LEN(A1)-1)),"",LEFT(A1,1)+RIGHT(A1,LEN(A1)-1))

 

[Scott Huish]

Perhaps:

=IF(A1<10,A1,LEFT(A1)+RIGHT(A1))