| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum numbers thru specifying the amount from another cell? | Excel Discussion (Misc queries) | |||
| Is this possible ??? | Excel Discussion (Misc queries) | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Extract numbers from cell with Text and Numbers | New Users to Excel | |||
| create a cell that accumulates, numbers from another cell... | Excel Discussion (Misc queries) | |||
Linear Mode
