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

[Victoria_Hay]

Hi Ron,

Thanks for your question! As we noted in email, we do not currently support carriage returns in formulas. We apologize for any inconveniences this may cause for you and other users.

[Ron_Wessling]

That’s why I posted here to the Feature Request forum.

[Victoria_Hay]

Hi Ron,

Thanks for doing so! I added a message to make it clear for other users that we do not currently offer this feature. Please feel free to let us know if you have any other requests or feedback!

Thanks,

Victoria

[John_McNamee]

This would be a GREAT feature for me also. Thanks!

[shanti_rubens]

Yes, i would love this feature too!!!

[Shane_Robinson]

Absolutely needed/required for CONCATENATE function.

[Julien_Lafleur]

Great feature to add!

[Fabio_Vitali]

yes please, I want this, too!

[Tim_Dietrich]

Here’s a way to use carriage returns with the CONCATENATE function:

1. Add a Long Text column to your table. I name it “CR” so that it is easy to recognize.

2. Click into the field, press return, and add the text “[CR]” (without the quotes) to the second line. Be sure to set the value for every row in the table. (You can “fill down” to do this.)

3. Add a Formula field that concatenates your fields, and place the CR field where you need it. Wrap the CONCATENATE function with the SUBSTITUTE() function, so that the “[CR]” value is replaced with an empty string. For example: SUBSTITUTE(CONCATENATE(Name, CR, {Street 1}, CR, {Street 2}, CR, City, ", ", State, " ", Zip), “[CR]”, “”)

In Airtable, the Formula field will appear to be “flat” (as if there are no carriage returns in it). However, if you copy and paste the field into another application, or if you export the table, you should see that the carriage returns are actually there.

Attached are a few screen shots that might help explain the technique. If you need me to clarify anything, let me know.

I hope this helps.

~ Tim

The “CR” field:

The Formula field:

[Bruno_Carvalho]

You can simply use “\n”. Like this:
CONCATENATE({Name}, “\n”, {Attachments})

It will work.