close
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 quot;Bld 6, Flr 7, Rm 20quot;
Any ideas?Hi don
=A1amp;quot;, quot;amp;B1amp;quot;, quot;amp;C1
--
Regards
Roger Govierquot;donquot; gt; wrote in message
...
gt; Does anyone know how to take the contents of three columns in Excel
gt; and merge
gt; them into a single column? Preferably adding characters if possible.
gt;
gt; For example
gt;
gt; col1 = bld 6
gt; Col2 = flr 7
gt; Col3 = rm 20
gt;
gt; End result should be quot;Bld 6, Flr 7, Rm 20quot;
gt;
gt; Any ideas?
gt;
全站熱搜
留言列表
