& to combine cells/Keep formats

  • Thread starter Thread starter jlclyde
  • Start date Start date
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
 
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

Formula with Cell reference to include formating? 13
keep source formatting when concatenating 1
Combining a string of text 3
Concantenate which keeps bold of some parts. 5
Excel Conditional Formatting 1
Conditional Formatting with if statement 1
Keeping cell formatting 1
protect cell format 1

Back
Top