Forum Discussion
Calculate simple equation which is included in one cell..
All cells in the Column contain more than one value in each cell , that they were entered by using Alt+enter .. I want a formula to sum the values in each Cell .. Exmp. the Cell A1 contains 100 20...
Abdullah, perhaps this http://stackoverflow.com/questions/25316094/split-a-string-cell-in-excel-without-vba-e-g-for-array-formula idea with array will help, but i dind't try that myself