# Adding line breaks in the concatenate function

**URL:** <https://community.hubspot.com/t/adding-line-breaks-in-the-concatenate-function/145448>\
**Category:** Data Hub\
**Tags:** object\
**Created:** [January 28, 2026, 3:20am UTC](https://community.hubspot.com/t/adding-line-breaks-in-the-concatenate-function/145448 "2026-01-28T03:20:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![RRoques](https://avatars.discourse-cdn.com/v4/letter/r/e9bcb4/32.png) [@RRoques](https://community.hubspot.com/u/RRoques)\
**Post date:** [January 28, 2026, 3:20am UTC](https://community.hubspot.com/t/adding-line-breaks-in-the-concatenate-function/145448/1 "2026-01-28T03:20:25Z")

</div>

Hello,

I want to create a multi-line text field that concatenates several other multi-line text fields.

I created a property as follows:

- “calculation” field type,

- “custom equation” calculated property type,

- “String” output type.

This property is in the deals object and concatenates several text fields. I use the concatenate function.

I want to insert line breaks between the fields I’m concatenating.

I tried “\n” or “\<br\>” without success.

Is there a solution to insert line breaks?

Regards, Remi

---

<div class="post-metadata">

**Author:** ![EugeneAtKiwi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/eugeneatkiwi/32/80399_2.png) [@EugeneAtKiwi](https://community.hubspot.com/u/EugeneAtKiwi)\
**Post date:** [January 28, 2026, 4:43am UTC](https://community.hubspot.com/t/adding-line-breaks-in-the-concatenate-function/145448/2 "2026-01-28T04:43:59Z")

</div>

Hey @RRoques

I believe the strings in the calculation properties do not support line breaks, but you can make this work with a workflow. If you create a multi-line text or rich text property for the result of concatenation, all you have to do is set up an “Edit Record” action in a workflow to edit this resulting property and set a value using your other multi-line text properties and optionally adding some other text if necessary.

If you use a Rich text property, you can also use HTML tags to format the resulting output.

 ![SCR-20260127-tone.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/6/6af53d5039d5badc321a77eee394446b15c9cff2.png)

---

<div class="post-metadata">

**Author:** ![RRoques](https://avatars.discourse-cdn.com/v4/letter/r/e9bcb4/32.png) [@RRoques](https://community.hubspot.com/u/RRoques)\
**Post date:** [February 13, 2026, 1:58am UTC](https://community.hubspot.com/t/adding-line-breaks-in-the-concatenate-function/145448/3 "2026-02-13T01:58:07Z")

</div>

Thank you very much, EugeneAtKiwi, for proposing a solution to my problem. I am sorry that it took so long to come back to you. I have been very busy over the last few weeks.

I tried your solution, but I am now facing another problem:

Due to a multi-text property not being a calculation, I cannot exclude a text field from the roll-up multi-text property if the text field has no value. If several text fields are empty, I end up with several blank lines. Is there a way to exclude text fields that are empty with your solution?

See the screenshot below.

 ![Screenshot 2026-02-13 125332.jpg](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/6/06d1bb73f7969a9ff63af1dcd5b0353e0f1f7883.jpeg)

Thank you very much for your consideration.

---

<div class="post-metadata">

**Author:** ![EugeneAtKiwi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/eugeneatkiwi/32/80399_2.png) [@EugeneAtKiwi](https://community.hubspot.com/u/EugeneAtKiwi)\
**Post date:** [February 13, 2026, 4:17am UTC](https://community.hubspot.com/t/adding-line-breaks-in-the-concatenate-function/145448/4 "2026-02-13T04:17:14Z")

</div>

Hey @RRoques ,  
Well, you could use IF-branches, but covering all possible combinations of empty/non-empty properties would require an insanely huge workflow in this case. A quick fix would be to add some delimiters to better indicate missing values.  
So instead of having something like this in workflow:  
[property\_name\_1]  
[property\_name\_2]  
You’d have something like this:  
Q1: [property\_name\_1]  
Q2: [property\_name\_2]  
Then it will result in something like:  
Q1: Here’s some text  
Q2:  
For a more solid solution, you’d need Data Hub Pro or higher to use the Format Data action in [Custom Mode](https://knowledge.hubspot.com/workflows/format-your-data-with-workflows#format-your-data-with-a-custom-formula) to use [concat function](https://knowledge.hubspot.com/workflows/custom-formula-functions)

 ![SCR-20260212-tfpb.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/e/fe5ae6a5e76263f371f8262bb8b3f38f9762629e.png)

 ![SCR-20260212-tgjz.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/0/0f9f8795cc50e14d92a52f91f6ddb5149174f924.png)

---

<div class="post-metadata">

**Author:** ![RRoques](https://avatars.discourse-cdn.com/v4/letter/r/e9bcb4/32.png) [@RRoques](https://community.hubspot.com/u/RRoques)\
**Post date:** [February 17, 2026, 3:13am UTC](https://community.hubspot.com/t/adding-line-breaks-in-the-concatenate-function/145448/5 "2026-02-17T03:13:00Z")

</div>

Thank you, Eugene. The DataHub option is the way forward. Thank you again.