Note that this doesn't separate the entries by a comma.

See

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

for an alternative.

In article ,
Gary''s Student wrote:

Enter and use this tiny UDF:

Function concat(r As Range) As String
Dim rr As Range
concat = ""
For Each rr In r
concat = concat & rr.Value
Next
End Function
--
Gary''s Student


"eeehwc" wrote:


I have some words in 50 different cells, how can I put them togehter
into 1 single cell and seperated by comma by a formula.