View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
davesexcel[_63_] davesexcel[_63_] is offline
external usenet poster
 
Posts: 1
Default concatenate formatted cells in excel


=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