Combine two columns into one

[skeen503979]

Hello!

Can someone please tell me how to combine two different columns into one?  I've got some data with two possible addresses.  There are no duplicates between address A or address B.  I just need a clean column that shows an address (whether it's A or B).  The addresses have numbers and letters which need to be preserved.  Did I input the formula correct below?  

If not, how can I do this?

[Emil_Kos · Accepted solution]

Hi @skeen503979,

I have made two solutions for you but I believe the first one will suit your needs:

[skeen503979]

Thanks @Emil_Kos.  The first solution (where you just add "+" instead of "and") worked great.

Thx!