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...
Hi Abdullah,
If you have access to Power Query then that can also provide a possible solution
Power Query can be used to split cells containing Alt+Enter and then a few extra Power Query steps allows you to sum those figures. I've attached a demo file
I agree with Wyn, with Power Query it's easier - if you use it
