How to enter line breaks in formula?

elnath78
11 ●4 ●9 ●15

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

3019 ●2 ●12 ●50

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 +0100 )edit

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

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

1 follower

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

Seen: 1,389 times

Last updated: Feb 14 '20