Carriage Returns in CONCATENATE

[Ron_Wessling]

Add the ability to use a carriage return when using the CONCATENATE function.

Name&CarriageReturn&Street&CarriageReturn&State&","&Zip

[Daniel_Robbins]

I tried this but, at least within the field display itself, I don’t see any carriage returns. Is this only for export?
I am using a formula like this:
CONCATENATE( Name,"\n",{Address 1},{Address 2},"\n",City)
Thanks,

[Bruno_Carvalho]

@Daniel_Robbins Have you tried copying from the cell in the grid view? It worked for me.

I will show exactly the answer:

“Name
{Address 1}{Address 2}
City”

[Daniel_Robbins]

Yes, I noticed that on paste the carriage returns are there. I wish they’d show up in the cell too…

• Dan

[Bruno_Carvalho]

They don’t show up because formula fields are treated as single line fields. I think we should be able to generate a formula for any kind of field we like.

[Chris_Kennedy]

Any way to remove the quotes from the output? Can’t think of one myself…

[shanti_rubens]

Thanks, that’s super helpful!

[Andrew_Enright]

Hello all, I’m happy to report that the carriage returns display as expected if you increase row height.

Unfortunately though, the resulting copy block is still wrapped in quotes once copied and pasted. Has anyone worked out a way to omit those quotes?!

[W_Vann_Hall]

Andrew_Enright:

Unfortunately though, the resulting copy block is still wrapped in quotes once copied and pasted. Has anyone worked out a way to omit those quotes?!

Nope — but here are a few additional points about them

• Actually, you can bypass the quotes: If, instead of copying the entire cell, you mark-and-copy the cell contents, the resulting text is pasted without enclosing quotes, even if the copied text contains embedded commas or newlines. You truly do have to mark-and-copy — as in click and drag — as pressing Ctrl-A marks the entire page, even if you have the expanded field open and selected. Obviously, not really a work-around, but may be useful if only occasionally needed.

• The enclosing quotes are only obvious if you copy from Airtable and paste to another app; however, they are included in a paste to another Airtable cell, and they affect how the pasted data is interpreted:

  • Pasting a value containing an embedded newline without enclosing quotes — that is, one copied using mark-and-copy — into either a single-line text or a long text field will paste only the text up to the newline in the current cell, with text following the newline (presumably up to the end of the file or the next newline encountered) appearing in the cell below the current one. If there are insufficient rows, Airtable will prompt to confirm the user wishes to add records.
  • Pasting a value containing an embedded newline with enclosing quotes — as when the entire cell is copied — into either a single-line or a long text field pastes the entire value into the current cell.

[Andrew_Enright]

@W_Vann_Hall This is a REALLY helpful explanation, thank you! A keyboard-only solution is ideal, but we’ll look at drag-and-drop.

[W_Vann_Hall]

Andrew_Enright:

A keyboard-only solution is ideal, but we’ll look at drag-and-drop.

I should clarify, as my original phrasing wasn’t clear: By mark-and-copy, I meant placing the cursor at the beginning of the desired text, depressing the mouse button, and, while continuing to hold it down, dragging the cursor to the end of the desired text. At that point press Ctrl-C to copy, select the targeted app or field, and press Ctrl-V to paste. Selecting the highlighted text, holding down the mouse button, ‘dragging’ the text to the desired target, and ‘dropping’ it in place may work, but I’ve not tested it. (I’m sure you understood, but I wanted to be sure not to mislead any potential readers who stumble across this exchange in the future who aren’t UI/UX legends. :winking_face: )