& to combine cells/Keep formats

J

jlclyde

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
 
S

Sheeloo

Sorry, that can not be done using formulas provided by Excel.

One has to use VBA to develop a function to this.
 
Top