Hi Pecoflyer,

Let's say I have this text residing in 6 adjacent cells (i.e. successive columns), in the same line:

Stipa lessingiana L. subsp. lessingiana Soo

So columns A, B are bold, column C is normal, column D is italic, column E is bold, column F is normal.

Now, I want to concatenate the whole lot and retain the formatting

Stipa lessingiana L. subsp. lessingiana (Heuffel) Soo - in one cell ! - say in column G.

instead of

Stipa lessingiana L. subsp. lessingiana (Heuffel) Soo

which is what I get when I use the "&" operator to concatenate the source cells.