# single / double numbers in cells

#### youngie

##### New Member
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

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### Scott Huish

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

#### jammoca

##### Banned
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

##### MrExcel MVP
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

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

Thanks

#### jammoca

##### Banned
try this ....

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

#### Scott Huish

##### MrExcel MVP
Perhaps:

Code:
``=IF(A1<10,A1,LEFT(A1)+RIGHT(A1))``

Replies
5
Views
477
Replies
4
Views
203
Replies
5
Views
646
Replies
10
Views
489
Replies
1
Views
472

1,191,416
Messages
5,986,438
Members
440,030
Latest member
ninomato

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back