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.
|