Thread: urgent, help!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default urgent, help!

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