urgent, help!

[eeehwc]

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.

 

[Gary''s Student]

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

 

[JMay]

If
A1 = Have
A2 = a
A3 = nice
A4 = Holiday
then
in B1 enter = A1&" "&A2&" "&A3&" "&A4
B1 will show Have a nice holiday

HTH

 

[JE McGimpsey]

Or, separated by a comma:

=A1 & "," & A2 & "," & A3 & "," & A4

 

[JE McGimpsey]

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

See

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

for an alternative.

 

[JMay]

sorry, before my 2nd cup of coffee;;
da..........