How to keep text formatting when using AutoCopy Formula

Hi All,


Let's say that I want cell B1 to autocopy cell A1, I will use =A1. However, let's say that the text in A1 goes as follows "text in bold and text not in bold" , what formula must I use so that it reproduces the exact same text formatting?


Thanks in advance!


Joshua