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