On 26 Apr 2007 18:39:11 -0700, Lunch wrote:

THe entire cell is not formated the same. Some of it is bold/
underline another part of it is italics

In that case, instead of a formula, you will need to use VBA to concatenate the
string; insert the string into the cell; and then format the sections as you
desire.

Nick's routine gives an example of how to do that.
--ron