merge contents in excel
 

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?

merge contents in excel
 

Hi don

=A1&", "&B1&", "&C1

--
Regards

Roger Govier


"don" wrote in message
...
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?