I have a cell containing a text string with a specific format, e.g. one char underlined, another word in bold.
When I reference the cell through a link (e.g. in B1: =A1) I do get the characters, but I lose any formatting of the original cell. Is there any way to maintain formatting of the original cell in a linked cell?
Example:
A1: value: the **quick** *br*own fox
B1: Formula: =A1 value: not just the quick brown fox but the **quick** *br*own fox