ExcelBanter - Two numbers in one cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Two numbers in one cell (https://www.excelbanter.com/excel-discussion-misc-queries/112137-two-numbers-one-cell.html)

Two numbers in one cell

I want to enter two numbers in one cell, separated by a space or dash. I then
want to use a formula to sum the left hand number in one cell and the sum of
the right hand numbers in another cell. I would prefer to use a cell formula
to accomplish the above. Thanks, in advance, Jed

Two numbers in one cell

Hi,

=VALUE(LEFT(A1,FIND(" ",A1,1)))+VALUE(MID(A1,FIND(" ",A1,1),LEN(A1)))

with your nzmbers in cell A1 and separated by a space ...

HTH
Cheers
Carim

Two numbers in one cell

left side:
=SUM(VALUE(LEFT(A1:A3,FIND(" ",A1:A3,1))))
right side:
=SUM(VALUE(MID(A1:A3,FIND(" ",A1:A3,1),LEN(A1:A3))))

Both are array formulae, confirm them with Ctrl+Shift+Enter! Adjust A1:A3
range to your needs!

Regards,
Stefi

€žJed94568€ ezt Ã*rta:

I want to enter two numbers in one cell, separated by a space or dash. I then
want to use a formula to sum the left hand number in one cell and the sum of
the right hand numbers in another cell. I would prefer to use a cell formula
to accomplish the above. Thanks, in advance, Jed