Hi

I currently have three cells that I want to link to one cell via the formula "=A1&A3&B4". But cell A3 has bold text in it and I want to be able to preserve the bold text. How do I do that? Is that even possible?

To give you an idea of what it is I am doing (for possible work around ideas):
I have created an Excel sheet that makes e-mail writing easier for me with templates that automatically copy to my clipboard. Now the cell that displays the final E-Mail that should be copied to the clipboard is made up a formula that is pulling information out of multiple cells. The e-mail has one word (in the signature) that should be bold. It HAS to be bold (unfortunately)... And I can't figure out how I can do this.
Does anyone have an idea on how I could do this?

It would be a massive help!

Cheers
Aidan