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.
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.