One way:

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

Alternatively, you could use the UDF he

http://www.mcgimpsey.com/excel/udfs/multicat.html


=MultiCat(A1:F1,",")

In article ,
Banana wrote:

I have multiple columns each containing data that i now need to represent in
one final cell for each row. Can i merge the date with comma separators?