Preserve Formating

[david.fielding]

Thanks in advance is there any way to preserve formating when
concantenating strings for example


example one


"example" would be aerial font and "one" would be times new roman font,
italic bold for instance


If it is not possible with a formula what about a worksheet function or
a macro


Cheers
David