How to calculate the sum in this situation?

[rufiqcavadov]

Hello everyone,

In Excel, I entered two numbers in a single cell by using the Alt+Enter command to add a line break. I want to calculate the sum of these numbers, but I don't want to use VBA.

I know ChatGPT can write VBA code, but I am looking for a non-VBA solution. Could someone help me with this?

Thank you in advance!

 

[Fluff]

How about

=LEFT(G7,FIND(CHAR(10),G7)-1)+MID(G7,FIND(CHAR(10),G7)+1,100)

 

[rufiqcavadov]

How about

=LEFT(G7,FIND(CHAR(10),G7)-1)+MID(G7,FIND(CHAR(10),G7)+1,100)

What does "Char(10)" mean?

Specially 10?

 

[Fluff]

It's a linefeed character (ie Alt Enter)

 

[rufiqcavadov]

It's a linefeed character (ie Alt Enter)

Okay, understandable. Thank you for helping. I want to ask something else. Is it a short form of this function?

For Example. This function only works for G7 row.

 

[Fluff]

You can drag the formula down for other rows.

 

[Cubist]

It's a bit more challenging without TEXTSPLIT in 365, but you can try:

Book2
	G	H	I
7	1500 2500		9000
8	1500 3500
Sheet4

Cell Formulas
Range	Formula
I7	I7	=LET(c,CHAR(10),t,TEXTJOIN(c,,G7:G8),r,LEN(t) - LEN(SUBSTITUTE(t,c, ""))+1,e,LEN(t),SUM(--MID(SUBSTITUTE(t,c,REPT(" ",e)),(SEQUENCE(r)-1)*e+1,e)))

 

[rufiqcavadov]

You can drag the formula down for other rows.

 

[Fluff]

Are you trying to add all the cells together to give one total?

 

[rufiqcavadov]

Are you trying to add all the cells together to give one total?

Yes