How to enter line breaks in formula?

elnath78
9 ●3 ●8 ●11

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

1 Answer

Sort by » oldest newest most voted

1841 ●1 ●6 ●31

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.

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

elnath78 ( 2020-02-17 13:46:24 +0200 )edit

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

keme ( 2020-02-17 17:31:08 +0200 )edit

1 follower

Asked: 2020-02-14 13:54:20 +0200

Seen: 440 times

Last updated: Feb 14