| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Cells that Contain Text
This would work, as long as there's a space between the value on the left and
the hyphen: =VALUE(LEFT(A1,FIND(" ",A1,1)))+VALUE(LEFT(A2,FIND(" ",A2,1))) -- Kevin Backmann " wrote: Is there anyway that I can add two cells ie. cell 1 - (5 - Oranges) cell 2 - (6 - Grapes) and get a sum of 11 in the third cell...i cant just use the sum function because of the text being in the cells |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding symbols to text cells | Excel Worksheet Functions | |||
| Adding a lot of text to MS Excel cells | Excel Discussion (Misc queries) | |||
| Adding two text cells together | Excel Discussion (Misc queries) | |||
| Adding cells, using text as number | Excel Discussion (Misc queries) | |||
| Adding cells with numbers and text | Excel Worksheet Functions | |||
Hybrid Mode
