Ask Your Question

How to enter line breaks in formula?

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

elnath78 gravatar image

updated 2020-02-14 14:49:15 +0100

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-02-14 15:26:09 +0100

keme gravatar image

updated 2020-02-14 15:31:24 +0100

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.

edit flag offensive delete link more


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

elnath78 gravatar imageelnath78 ( 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 gravatar imagekeme ( 2020-02-17 17:31:08 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 1,389 times

Last updated: Feb 14 '20