ExcelBanter - CONCATENATE preserving original formating

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - CONCATENATE preserving original formating (https://www.excelbanter.com/excel-programming/403724-concatenate-preserving-original-formating.html)

Fishnerd

CONCATENATE preserving original formating

How do I preserve the original formating/fonts/colors/etc of text in two
cells when I CONCATENATE them into one cell?
Thanks!

Please help

CONCATENATE preserving original formating

Have you tried Format Painter from the toolbar?

"Fishnerd" wrote:

How do I preserve the original formating/fonts/colors/etc of text in two
cells when I CONCATENATE them into one cell?
Thanks!

Fishnerd

CONCATENATE preserving original formating

How would I go about using this to preserve the 2 different formats from the
text in 2 different cells when they merge into one using CONCATENATE? When I
try using Format Painter it just copies the formating from one or the other...

"Please Help" wrote:

Have you tried Format Painter from the toolbar?

"Fishnerd" wrote:

How do I preserve the original formating/fonts/colors/etc of text in two
cells when I CONCATENATE them into one cell?
Thanks!

All times are GMT +1. The time now is 10:34 PM.