merge contents in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Back
Top