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

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?

One way:

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

Alternatively, you could use the UDF here:

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


=MultiCat(A1:F1,",")

In article <AEEC8296-91AD-41BD-985A-37590284F84C@microsoft.com>,
Banana <Banana@discussions.microsoft.com> 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?