Joining 2 columns

[micou]

Hello,

I want to combine the data in column A and column B and the desire output is attached below. 

Can someone please teach me how to do it. Thank you!

[markcurry · Accepted solution]

This formula should do it ..

[Column A] + " - " + ToString([Column B])

As Column B is numeric, you'll need to convert that to a string with the ToString function.

[Greg_Murray]

In a formula tool create a new field with the following expression:

[column A] + ' - ' + tostring([column b])