Add number in single cell

[Anos]

Sir how to add number in a single of excel without using VBA or macro suppose I have to add numbers 24+51+53 in single cell numbers can go into 3 to 4 digits like 200+4000+5000 can this be solved without using VBA or macro only by formula present in excel

 

[Sufiyan97]

Hi & Welcome to MrExcel.

Do you want just total for these numbers?

Book3
	A	B
1
2	128
3	9200
4
5
Sheet5

Cell Formulas
Range	Formula
A2	A2	=24+51+53
A3	A3	=200+4000+5000

 

[Anos]

yes but how to add it please explain

 

[AhoyNC]

Like this?

Book2
	A	B
1	24+51+53	128
2	200+4000+5000	9200
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=SUM(TEXTSPLIT(A1,"+")+0)

 

[Dave Patton]

Another approach
=LAMBDA(Text,EVALUATE("=" & Text))

LAMBDA.xlsm
	A	B
4	24+51+53	128
5	200+4000+5000	9,200
6	200 + 4000 + 5000	9,200
7	4553-4610	-57
8	50 + 50	100
9	50+50	100
10	12*8	96
11	12 * 9	108
12	2+4+6-10	2
13	21/3	7
14	(270-100)*(4-2)	340
15	10^5	100,000
1g

Cell Formulas
Range	Formula
B4:B15	B4	=EvalCell(A4)

 

[Anos]

Like this?

Book2
	A	B
1	24+51+53	128
2	200+4000+5000	9200
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=SUM(TEXTSPLIT(A1,"+")+0)

I can't use it in 2021 Excel please explain it so I can use it in excel 2021