Preserving text formats with Concatenate function

[rufus]

hi all,

apologies for the potential double post, but my original one does not
seem to have ever made it out to google groups from my local news
server.

At any rate, here's the question:

I need to combine a series of cells that each have different sorts
of text formatting involved. For example:

-Cell A1 could have the word "train" in standard 12 font
-Cell B1 could have the word "train" in bold 12 font
-Cell C1 could have the word "train" in standard 14 font

etc.

For the life of me I can't find a way to preserve the formatting of
each
entry once they are combined into a cell using either concatenate or
simple '&' functions.

Just to head off a possible suggestion, I have tried specifically
formatting a given cell with the combination of font sizes and bolding
that I need, and then just doing a "copy -> paste special -> formats"
onto my combined cell. This worked, but unfortunately, the cells
I need to combine usually do not contain the same numbers of digits
and
letters, so there's no way to automate this process in a way that
would
actually save any time.

Thanks much for any suggestions.

-j

 

[Frank Kabel]

Hi
formulas can't return formats. they only return values. So no chance to
preserve the format infomation within you concatenation formula

 

[rufus]

I feared that was indeed the case.

Thanks much for making it definitive.

-j