Text formatting/markup in a formula - possible?

Hi all,

Pretty sure this is not possible (I've googled it and found nothing so far) but I am trying to create a formula in Excel 2007 that allows me to markup the output a little like HTML to get bold/italic text – an example would be something like this:

="This is my first name in bold text:< B>" & B2 & "</ B>and this is my last name in italics< i>" & B3 & "</ i>"

(NB: I had to put spaces in the tags to stop the forum engine rendering them as HTML.)

This is a very simplified example - I am trying to develop test cases for a project I'm on and the output format I'm trying to reproduce automatically has quite a lot of sort of formatting with each formula referencing values from 10-20 other cells that need to be in bold/italic.

So is it possible to do anything like this in Excel 2007?

TIA for any suggestions... I have 100's of test cases to write and I want to automate it as much as possible!

Mike

Thanks for that DonkeyOte - I suspected not but I thought I'd ask just in case I was missing something. I've got it as automated as I can get it now - guess I'll just have to do the formatting by hand.... not ideal but the automation should still save me abut 2 days of the most boring, tedious work know to mankind. :-)