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