Line breaking in concatenate function

1

Would anyone know if there is any way to create line breaks in the concatenate function? Something kind </ p> <br > \ r \ n

Ex. =concatenate(‘String 1’, </*p>,‘String 2’,</*p>,‘String 3’)

PS: without the *

1 Like
2

It’s possible with a bit of a hack. You can “store” a line break in a cell (create a table for it somewhere, and hit ctrl-enter to create a line break). So you can:

  1. Create a 2 column table - first column is Name, second column is Value
  2. In the first row - fill in Name as “Enter” and Value as a single ctrl-enter line break
  3. From your function, refer to that cell as @Enter.Value - e.g. =concatenate(“a”, @Enter.Value, “b”)
1 Like
3

Many thanks Shishir.
Through this tip I was able to concatenate the text as I wished.

4

Hi @shishir, does this still work? Can’t get it to. Works within coda, but once the email is sent, it seems the line break is stripped away.

5

Another option for a line break is Character(10)

Example:
Concatenate("Hello",[Name],Character(10),"Sending this email to catch up!",Character(10),"Thank you!")

I haven’t tried this recently with sending in an email, but it does work with Slack, so I think it will work with Gmail too.

8 Likes
6

This is no longer work any more. Is there any alternative?

7

@Danny_Thakur The easiest way is to break the line in the formula editor, one advantage is that it already looks like your result in the formula editor.

8

chiming in that Character(10) works perfectly and can be used in line in a concatenate function

9

Or lineBreak()!

With Coda 3.0 came a new formula that is a functional equivalent of character(10)

4 Likes
10

Well that’s a bit easier to remember at least :slight_smile:

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.