Skip to main content
andr_raposo
Helper ⭐️
June 3, 2024
Solved

Line break when concatenating

  • June 3, 2024
  • 2 replies
  • 171 views

Hi community,

May be a simple question but we’re trying to concatenate a few string/text fields into a Rich text area field that lives in the Company object.

 This is very easy, however, for the new field to be somewhat readable we would like to have a line break between which field we’re concatenating. 

Is there a way to add a line break when using the concat formula? If not, any workaround? 

 

Thanks you all

Best answer by alizee

@andr_raposo Rich text supports HTML formatting, so have you tried concatenating <br> and see what the result looks like? This is a quick suggestion but not sure of the result. 

2 replies

alizee
alizeeAnswer
VIP ⭐️⭐️⭐️⭐️⭐️
June 3, 2024

@andr_raposo Rich text supports HTML formatting, so have you tried concatenating <br> and see what the result looks like? This is a quick suggestion but not sure of the result. 

The most expensive part of building is the mistakes. That's true in construction. Not so much in CSOps. So ask questions, make mistakes and learn. All views expressed here are my own.
Gainsight Employee ⭐️
August 8, 2025

While applying the line break HTML tag, it is observed that the approach works for Rich Text field. However, the same is not replicable while loading data to Long Text field in SFDC.