display text and its formatting in other cell

**Ricky's Dad** · 10-09-2008, 04:53 PM

Without using a copy/paste macro, is there a way to display the text and its formatting from another cell? Obviously, the usual formula "= A2" only brings the text from that cell. Example:

A3: un-am-big-u-ous

G4: = A3 (but I want the font formatting used here as well)

Many thanks -

**protonLeah** · 10-10-2008, 02:12 PM

Since you are using the word "display", please try the CAMERA tool.

**Ricky's Dad** · 10-12-2008, 11:14 AM

Originally Posted by protonLeah

Since you are using the word "display", please try the CAMERA tool.

I had not seen this camera tool before; very cool and thanks for suggesting it. But I'm hoping for something that I can use within a formula, such as with vlookup, so I can pull the text and its formatting from various cells, given the context. Any ideas?

**shg** · 10-12-2008, 11:34 AM

But I'm hoping for something that I can use within a formula, such as with vlookup, so I can pull the text and its formatting from various cells, given the context.

Short answer, not possible.