# How to Concatenate 2 Single Select fields into text

**URL:** <https://community.fibery.io/t/how-to-concatenate-2-single-select-fields-into-text/1142>\
**Category:** Get Help\
**Created:** [November 9, 2020, 1:14am UTC](https://community.fibery.io/t/how-to-concatenate-2-single-select-fields-into-text/1142 "2020-11-09T01:14:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Proteinbery](https://avatars.discourse-cdn.com/v4/letter/p/47e85d/32.png) [@Proteinbery](https://community.fibery.io/u/Proteinbery)\
**Post date:** [November 9, 2020, 1:14am UTC](https://community.fibery.io/t/how-to-concatenate-2-single-select-fields-into-text/1142/1 "2020-11-09T01:14:21Z")

</div>

I have a table with columns [Exchange] and [Ticker]. These are both single select types.

I wish to make the primary key [Exchange] + ": " + [Code] but I get this error

`Cannot add Tickers Exchange and Tickers Code`

Is there a way around this?

,Thanks

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [November 9, 2020, 6:29am UTC](https://community.fibery.io/t/how-to-concatenate-2-single-select-fields-into-text/1142/2 "2020-11-09T06:29:33Z")

</div>

Try  
Exchange.Name + “:” + Ticker.Name

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [November 10, 2020, 11:28am UTC](https://community.fibery.io/t/how-to-concatenate-2-single-select-fields-into-text/1142/3 "2020-11-10T11:28:54Z")

</div>

Just noticed that your original post is a bit confusing (are the single selects called Exchange and Tickers or are they called Exchange and Code?) so it’s possible that the right formula is actually

Exchange.Name + “:” + Code.Name

---

<div class="post-metadata">

**Author:** ![Proteinbery](https://avatars.discourse-cdn.com/v4/letter/p/47e85d/32.png) [@Proteinbery](https://community.fibery.io/u/Proteinbery)\
**Post date:** [November 11, 2020, 7:00am UTC](https://community.fibery.io/t/how-to-concatenate-2-single-select-fields-into-text/1142/4 "2020-11-11T07:00:23Z")

</div>

Thank you that worked 🙂