CONCATENATE preserving original formating

  • Thread starter Thread starter Fishnerd
  • Start date Start date
F

Fishnerd

How do I preserve the original formating/fonts/colors/etc of text in two
cells when I CONCATENATE them into one cell?
Thanks!
 
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...
 
You don't.

You must concatenate then change to "values" then format the bits manually or by
macro.


Gord Dibben MS Excel MVP
 

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

Concatenate with Formatting 2
how to copy content AND formating with vba 1
Macro storing as a date? 11
Looking for a Date forming function 3
Preserving number format in userform textbox 2
Concatenate Macro 5
Concatenate 1
concatenate strings 3

Back
Top