Combine cells with different font

[btadams]

This is either very easy of virtually impossible: Does anyone know if it's possible to combine the contents of two (or more) cells while retaining the font style of those cells. For example, one cell has Wingding font and another has Arial.

Thanks,

 

[pgc01]

Hi

If you mean as a result of a formula (like A1&A2), the answer is no, it's not possible. In a cell with a formula all the characters have the same format.

You can do it in vba. read each value, concatenate the text and change the fonts using the Characters property of the range object.

Hope this helps
PGC