& to combine cells/Keep formats

's Computer Specifications

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 Computer Specifications

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

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

"jlclyde" wrote:

> 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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine two cells without losing data cell formats	johncaleb	Microsoft Excel Programming	2	6th May 2010 09:44 PM
combine cells with different formats	Truong	Microsoft Excel Misc	4	17th May 2009 06:21 PM
combine cells with different formats	Truong	Microsoft Excel Misc	0	17th May 2009 02:57 PM
Combine cells with the same reference and combine quantities	brandon	Microsoft Excel Misc	2	17th Sep 2008 05:44 PM
How do I combine documents with different formats?	=?Utf-8?B?ZGV2cmlt?=	Microsoft Word Document Management	1	10th Aug 2006 12:54 PM