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.
Thank you very much.
--
eeehwc
------------------------------------------------------------------------
eeehwc's Profile: http://www.excelforum.com/member.php...o&userid=26704
View this thread: http://www.excelforum.com/showthread...hreadid=488331