Excel: Dupliate Text Exactly

Hi Does anyone know if it is possible to type text into a cell on sheet 1 and it be reproduced in another cell on sheet 2 and keep the formatting. i.e. the first word is in bold and then the following 10 words are not bold. I have managed to duplicate the text but not the formatting using ='Sheet One'!A1 but I can not get the formatting to stay the same. Any help greatly appreciated :-)

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of July 01, 2014.

For more resources for Microsoft Excel