ExcelBanter - & to combine cells/Keep formats

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - & to combine cells/Keep formats (https://www.excelbanter.com/excel-discussion-misc-queries/210959-combine-cells-keep-formats.html)

jlclyde

& to combine cells/Keep formats

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

Sheeloo[_3_]

& to combine cells/Keep formats

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

All times are GMT +1. The time now is 06:22 PM.