One way:
=A1 & "," & B1 & "," & C1
to do this with an entire column with a User Defined Function:
http://mcgimpsey.com/excel/udfs/multicat.html
or to use a macro to concatenate in place:
http://www.mcgimpsey.com/excel/subs/mergedata.html
In article ,
capnsean
wrote:
I guess spacing doesn't work, and I won't want to tempt fate in trying
html.
What I mean is this:
A1=x
B1=y
C1=z
I want to consolidate x y and z with commas in one cell = x,y,z