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

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!

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!

You don't.

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


Gord Dibben MS Excel MVP

On Sat, 5 Jan 2008 18:16:02 -0800, Fishnerd <(E-Mail Removed)>
wrote:

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