[Solved] Line break in function result

[Sykes]

One more request for today

I need a line break in the function result. Something like

=A1&"SOMETHING"&A2

where SOMETHING is a line break.

Can I do that somehow? While I can do Ctrl+Enter in the cell, it won't affect the function and the text is not split into 2 rows within the cell.

Thank you!

[keme]

The newline is control character number 10. It is not directly accessible from keyboard to insert into literal strings, so you need the CHAR() function:
=A1&CHAR(10)&A2

[Sykes]

Thanks again. I thought it's gonna be something like this, unfortunately this useful info is not documented.

If I ever go to Norway, I'll buy you a beer

[MrProgrammer]

… unfortunately this useful info is not documented.

But it is.

You can use the text function CHAR(10) to insert a newline character into a text formula.

[keme]

… unfortunately this useful info is not documented.

But it is.

You can use the text function CHAR(10) to insert a newline character into a text formula.

I'll still take that beer, if chance allows