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

[Andrew_Enright]

Again, thanks for the clarification. I did misunderstand; shoulda tested my assumption before posting! This method works. Cheers.

[Peter_Nelson1]

Would love carriage returns allowed in the Concatenate function. Also want a concatenated field to display as a scrollable Long Text field not just a Single Line!

[Prince_Jose_The]

Simply paste it in ‘notepad’ - Windows application. And, use the Find & Replace.
Steps:

1. Paste the AirTable data in Notepad
2. Press Ctrl+H
3. Type "
4. Press Alt+A
   This will find & replace all double quotes (") and replace with none.

I’m using this way. for the last 6-7 months.

[CottageKeeper]

Bruno_Carvalho:

CONCATENATE({Name}, “\n”, {Attachments})

Works great! Thanks!

[ZYGOTE_DEVELOPM]

Very very awesome thanks for this!