How to Concatenate 2 Single Select fields into text

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?


Exchange.Name + β€œ:” + Ticker.Name

1 Like

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

Thank you that worked :slight_smile: