View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default & to combine cells/Keep formats

Is there a way to combine cells similar to using the & symbol and keep
the formatting from the copied cell? If A1 = "Red" and it was bold
and B2 = "Blue" and it was in blue font. Is there a way in C1 to
=A1&B1 and keep the Bold formatting for red and the blue font for
Blue?
Thanks,
Jay