This can not be done using formulas.

You will have to use a macro...

"Truong" wrote:

I want to combine the contents of 3 cells that have different formats (e.g.
cell 1= normal text, cell 2=italics text, cell 3= normal text) so that I have
a new cell with originally differently formatted texts. Can anyone help me in
this? Thank you very much.
Truong