Calculate simple equation which is included in one cell..

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

Played a bit taken the approach from here https://www.mrexcel.com/forum/excel-questions/505622-text-numbers-same-cell-sum-numbers.html

For simplicity let assume your numbers are split by spaces, not by ALT+ENTER.

In A2 you have "200 3 4 6 2"

When

=SUMPRODUCT(
IF(
SUBSTITUTE(TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",10)),{1,2,3,4,5,6,7,8}*10-9,10)),",","")="",
0,
SUBSTITUTE(TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",10)),{1,2,3,4,5,6,7,8}*10-9,10)),",","")*1)
)

gives 215.

Here 10 in REPT is any number which is more than length of your biggets number

Array {1,2,..} is more than biggest number of numbers in your cells

First SUBSTITUTES compares with IF set extra members of array to 0 (othervise you'll have an error)

*1 close to end converts string array with numbers into the numeric array

You may use Evaluate Formula in Ribbon to check how it works.

And i guess you may use directly ALT+ENTER symbol in final formula

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