Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text and Value in Cell
Hi there, hope this is the correct forum.....would like some help with Excel.
Heres what I want to do: In cell A1 (for example) I want to add say...10 bananas, in cell A2 I want to say 25 apples, then I want to add the values only of 10 and 25 and display the result of 25 in A3. I know how to do that when text in cells A1 and A2 is NOT present, can this be done WITH text present in those cells? If yes.....how? Thanks in advance for your assistance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text and Value in Cell
Dear Harry
Yes this is the correct forum You can do this using a combination of functions . SEARCH to find the space and LEFT to get the numeric value Try the below in A3 =LEFT(A1,SEARCH(" ",A1))+LEFT(A2,SEARCH(" ",A2)) If this post helps click Yes --------------- Jacob Skaria "HarryP" wrote: Hi there, hope this is the correct forum.....would like some help with Excel. Heres what I want to do: In cell A1 (for example) I want to add say...10 bananas, in cell A2 I want to say 25 apples, then I want to add the values only of 10 and 25 and display the result of 25 in A3. I know how to do that when text in cells A1 and A2 is NOT present, can this be done WITH text present in those cells? If yes.....how? Thanks in advance for your assistance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text and Value in Cell
WOW! thats brilliant - thanks Jacob. I owe you a pint!
"Jacob Skaria" wrote: Dear Harry Yes this is the correct forum You can do this using a combination of functions . SEARCH to find the space and LEFT to get the numeric value Try the below in A3 =LEFT(A1,SEARCH(" ",A1))+LEFT(A2,SEARCH(" ",A2)) If this post helps click Yes --------------- Jacob Skaria "HarryP" wrote: Hi there, hope this is the correct forum.....would like some help with Excel. Heres what I want to do: In cell A1 (for example) I want to add say...10 bananas, in cell A2 I want to say 25 apples, then I want to add the values only of 10 and 25 and display the result of 25 in A3. I know how to do that when text in cells A1 and A2 is NOT present, can this be done WITH text present in those cells? If yes.....how? Thanks in advance for your assistance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text and Value in Cell
Cheers!
If this post helps click Yes --------------- Jacob Skaria "HarryP" wrote: WOW! thats brilliant - thanks Jacob. I owe you a pint! "Jacob Skaria" wrote: Dear Harry Yes this is the correct forum You can do this using a combination of functions . SEARCH to find the space and LEFT to get the numeric value Try the below in A3 =LEFT(A1,SEARCH(" ",A1))+LEFT(A2,SEARCH(" ",A2)) If this post helps click Yes --------------- Jacob Skaria "HarryP" wrote: Hi there, hope this is the correct forum.....would like some help with Excel. Heres what I want to do: In cell A1 (for example) I want to add say...10 bananas, in cell A2 I want to say 25 apples, then I want to add the values only of 10 and 25 and display the result of 25 in A3. I know how to do that when text in cells A1 and A2 is NOT present, can this be done WITH text present in those cells? If yes.....how? Thanks in advance for your assistance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter text in a cell to return a text value in same cell | Excel Discussion (Misc queries) | |||
Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
Copy text from cell to cell with one cell changing text | Excel Worksheet Functions | |||
linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
New text added to cell AFTER current text in same cell | Excel Worksheet Functions |