Bruce,

I tried to lay it out as best as I could in the original post, but
maybe it wasn't very understandable. word2 & word3 are both in column 3
(column 1 = plain text, -column 2 = italized text-, *column 3 = bold
text*) and that is where I'm running into my problem. I intially just
want a formula in column 3 to do this. Eventually I want a Macro to
look through a list of cells and have them all the different outputs
depending on what they find in column 1 and column 2. Hopefully this
makes things a little more clear.

Thanks,
Jen


--
JenBasch
------------------------------------------------------------------------
JenBasch's Profile: http://www.excelforum.com/member.php...o&userid=27369
View this thread: http://www.excelforum.com/showthread...hreadid=468872