Line break in the formula

[sharshra]

I have a heading included as part of dynamic array. In few columns of the header, I want to introduce the line break to have the header in 2 lines. I´m trying to use CHR(10) but getting an error. Can the experts suggest please?

Desired output:

excel problems.xlsx
	H
18	line 1 line 2
Sheet8

Error:

excel problems.xlsx
	C
17	#NAME?
Sheet8

Cell Formulas
Range	Formula
C17	C17	=LET( a, "line 1" & chr(10) & "line 2", a)

 

[hagia_sofia]

If you are using English version of Excel should not the function be CHAR instead of CHR?

 

[sharshra]

Good spotting! Thanks, @hagia_sofia. Now, I´m not getting the error but output is not in 2 lines. In my spreadsheet, I see them one after the other. Refer the screenshot below. But in the cell copied from my spreadsheet to here shows the lines one below the other!!! I don´t know what is happening

excel problems.xlsx
	C
17	line 1 line 2
Sheet8

Cell Formulas
Range	Formula
C17	C17	=LET( a, "line 1" & CHAR(10) & "line 2", a)

 

[MARK858]

Have you wrapped the cell?

 

[sharshra]

Thanks, @MARK858. Yes, it works when wrapped. But, I thought that irrespective of wrapped or not, it should come in 2 lines since CHAR(10) is there. Is that not correct?

 

[MARK858]

No, it has always been the case that you need to wrap the cell for CHAR(10) to display as multiple lines

 

[sharshra]

OK. Thanks, @MARK858