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