Two numbers in one cell

J

Jed94568

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
 
C

Carim

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
 
G

Guest

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to add numbers in same cell? 2
Numbers showing Up Centered in Cell ? 1
Changing Text To Numbers ? 1
Excel Sum numbers in cells that also contain text 34
Two formulas in on cell based on two numbers in another cell? 5
Help Writing a SUM Formula 5
Error when using Sum command 3
3 numbers in each cell aligned verticaly one number in each cell 1

Top