Does anyone know how to take the contents of three columns in Excel and merge
them into a single column? Preferably adding characters if possible.

For example

col1 = bld 6
Col2 = flr 7
Col3 = rm 20

End result should be "Bld 6, Flr 7, Rm 20"

Any ideas?