Hello! Is it possible to include “new line” characters to strings/text inside formulas? How would new lines (or carriage returns) be represented? Thank you! Edit: for example, I want to add a linebreak in a concatenate function. CHAR() doesn’t seem to work.
I don’t understand what you’re trying to say here? Example?
I want to include a linebreak in a concatenate function, for instance
@Mobile_Tuberculosis Just put a line break in quotes:
“this is line one and this is line two”
@tony. I tried it before and it didn’t work; I guess the function was put in when I wasn’t looking. This is great. Thanks again!
I wanted to do this, and it worked putting a line break in. The only problem was, when I came to export that column out to a pdf template, the line breaks disappeared, and the words ran into each other in the pdf template.
When using the CONCATENATE expression, you can use it like this…
CONCATENATE(“This is line one”,"
“,“This is line two”,”
In the App, yes. It writes them on separate lines in the spreadsheet (within the same cell). But not in a pdf template in a workflow… it doesn’t maintain the line breaks.