& 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

Combining two review markings into one 1
Multiple items selected multiple dependancies available 3
Unique Value Count in 3 Columns Using Search Criteria 0
Formula with Cell reference to include formating? 13
keep source formatting when concatenating 1
Images are pixelated when saving to PDF 0
conditional count of single occurences 4
Popups to look up on two variable columns 1

Top