=CONCATENATE(A1,B1,C1)
I have never heard of having multiple colors in one cell
you can also use
=A1&" "&B1&" "&C1
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=522024