Skip to main content

Hi - I’d like to be able to create a calculated multi-line field. My use case is turning 4 separate (Non-US) address fields into an address block for export. I’d like users to be able to copy and paste a multi-line address block for one-off letters etc (ie without export and merge).

I have created a calculated field with the formula:

((IF({Address 1} = “”, “”,{Address 1} & ", ") & IF({Address 2} = “”, “”,{Address 2} & ", ")) & IF({Address 3} = “”, “”,{Address 3} & ", ")) & Postcode

…but I’d like to be able to replace the comma and space with a New Line or New Paragraph mark.

Any suggestions gratefully received.

Be the first to reply!

Reply