# Advanced Calculated fields: Concat behavior

**URL:** <https://community.hubspot.com/t/advanced-calculated-fields-concat-behavior/87920>\
**Category:** HubSpot Ideas\
**Tags:** properties\
**Created:** [August 21, 2023, 12:52pm UTC](https://community.hubspot.com/t/advanced-calculated-fields-concat-behavior/87920 "2023-08-21T12:52:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![TH7](https://avatars.discourse-cdn.com/v4/letter/t/6a8cbe/32.png) [@TH7](https://community.hubspot.com/u/TH7)\
**Post date:** [August 21, 2023, 12:52pm UTC](https://community.hubspot.com/t/advanced-calculated-fields-concat-behavior/87920/1 "2023-08-21T12:52:22Z")

</div>

![TH7_0-1692621365117.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/0/60ed99e40e3df8443bebfae23a1cb81e5cd9a291.png)

When concatentating fields in an advanced formula, there is no way to include a space between the fields.

This includes wrapping the property in quotes and adding a space afterwards:

 ![TH7_4-1692621734382.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/d/bdfbee291c1be50d95167678638479269ec49ed2.png)

Here is the result on record:

 ![TH7_3-1692621674610.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/3/23133a26b6dbbc0d676cb13967725c80bc01516e.png)

As well as using tokenization curly braces:

 ![TH7_5-1692622183421.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/9/39318f203acc60f725e30bcf01998686bd4aca64.png)

Result on the record:

![TH7_6-1692622254983.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/5/5d77de4bdc1397970799df47ff3e3aae97171de0.png)

In fact, the formula appears to remove whitespace:

![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/a/e/aeda53dbe34fc30a1115547a3e344a2ea695fab1.png)

I tested this by putting a space after the label:

![TH7_2-1692621619520.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/b/fb89ce7629a6f15f57fbcbd0a5441acbed6eb74f.png)

This could be a cool little function, if we were allowed to control how it looks. I’m not looking for camel case. I just want to reduce the number of workflows I need to segment data.

Being able to use more than 2 strings, and/or pull out substrings would be nice too.

Thank you!

---

<div class="post-metadata">

**Author:** ![TH7](https://avatars.discourse-cdn.com/v4/letter/t/6a8cbe/32.png) [@TH7](https://community.hubspot.com/u/TH7)\
**Post date:** [December 15, 2023, 12:18am UTC](https://community.hubspot.com/t/advanced-calculated-fields-concat-behavior/87920/2 "2023-12-15T00:18:02Z")

</div>

UPDATE: Saw today that this has been fixed. We can now concatenate up to N values.

 ![Screenshot 2023-12-14 181910.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/8/88e550b77367fe65eba3b8db70e568d0be5cd1af.png)  
Fixed Concat

Additonally, we can combine concatenate with some powerful functions.

For example,

concatenate(number\_to\_string( year([properties.createdate])),“-”,number\_to\_string( month([properties.createdate])))

I was able to create a custom formatting for my create date property. This was a request made to enable easier reporting in spreadsheets: