How to enter line breaks in formula?

I want to use TEXT.JOIN() function but I need to add as delimiter a new line, how do I do?

Control character #10 is newline.

In a formula you can insert CHAR(10) as an element to be joined. This works well with the TEXTJOIN() function.

1 Like

this worked! where can I find a list of what number is every special character, for example say TAB or such?

This article on Wikipedia lists the control characters which may be useful in modern-day applications.