Hello! Is it possible to include "new line" c...

(Mobile Tuberculosis) #1

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.

(Grant Stead) #2

I don’t understand what you’re trying to say here? Example?

(Mobile Tuberculosis) #3

I want to include a linebreak in a concatenate function, for instance

(Grant Stead) #4

@Mobile_Tuberculosis hrmmm not sure… @Aleksi_Alkio

(Tony Fader) #5

@Mobile_Tuberculosis Just put a line break in quotes:

“this is line one and this is line two”

(Mobile Tuberculosis) #6

Thanks

@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!

(Green Gorilla) #7

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

(Aleksi Alkio) #8

When using the CONCATENATE expression, you can use it like this…

CONCATENATE(“This is line one”,"

“,“This is line two”,”

",“End of”)

(Green Gorilla) #9

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.

(Aleksi Alkio) #10

@Green_Gorilla That’s true. It will work with the Email body, but not with the Doc template.