View Single Post
 
Old 12-04-2011, 01:36 AM
mike_abc mike_abc is offline Windows XP Office 2003
Novice
 
Join Date: Dec 2011
Posts: 9
mike_abc is on a distinguished road
Default

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.
Reply With Quote