Formatting lost when copied by formula

[Guest]

Hi

I'm having a problem retaining format in a target cell where a formula "copies" the contents from another cell. Here's an example that describes the problem in detail

Say I have the following text in cell A1: "Some text." Say, also, that the word "text" is bolded. In cell B2 I have a formula, =A1, that "copies" the content of cell A1. I can see the content of cell A1 in B2, but without the bold (or any other formatting, including background color, etc.)

My question, of course, is how do I retain the original formatting

Thank you

 

[Frank Kabel]

Hi
no chance to do this with formulas (or user defined
functions). Formulas can only return value but not formats.

-----Original Message-----
Hi,

I'm having a problem retaining format in a target cell

where a formula "copies" the contents from another cell.
Here's an example that describes the problem in detail:

Say I have the following text in cell A1: "Some text."

Say, also, that the word "text" is bolded. In cell B2 I
have a formula, =A1, that "copies" the content of cell A1.
I can see the content of cell A1 in B2, but without the
bold (or any other formatting, including background color,
etc.).