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

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

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.

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

"eeehwc" wrote in
message ...

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

Or, separated by a comma:

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

In article <RCZhf.28032$4l5.1211@dukeread05, "JMay"
wrote:

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

"eeehwc" wrote in
message ...

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

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


"JMay" wrote in message
news:RCZhf.28032$4l5.1211@dukeread05...
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

"eeehwc" wrote in
message ...

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