How do i merge data in a row of cells to be comma separated in on.

Banana · Feb 7, 2005

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?

JE McGimpsey · Feb 7, 2005

One way:

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

Alternatively, you could use the UDF here:

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

=MultiCat(A1:F1,",")