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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

keep source formatting when concatenating 1
Formula with Cell reference to include formating? 13
Excel Conditional Formatting 1
Combining a string of text 3
Combine Text Cells 3
Change font color when making changes 5
Make cells formatting equivalent 1
Text changing colour when bolded? 3

Top