Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Carriage Returns in CONCATENATE

cancel
Showing results for 
Search instead for 
Did you mean: 
Ron_Wessling
6 - Interface Innovator
6 - Interface Innovator

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

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

25 Comments
Andrew_Enright
9 - Sun
9 - Sun

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

Peter_Nelson1
4 - Data Explorer
4 - Data Explorer

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
4 - Data Explorer
4 - Data Explorer

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
6 - Interface Innovator
6 - Interface Innovator

Works great! Thanks!

ZYGOTE_DEVELOPM
5 - Automation Enthusiast
5 - Automation Enthusiast

Very very awesome thanks for this!