On Apr 27, 6:03 am, Ron Rosenfeld wrote:
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

I'll take a look at it today and see if I can get it working. I don't
ahve a lot of VB experience so it's always an adventure.