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!