Reference cell formats + content
 

Hi.
How can I tell one cell to follow content AND/OR formating of another cell?
Here's an example:

A1:
=I am the <bbest!</b (<b...</b means bold letters)

A2:
=A1
Returns: =I am the best! (without bold)

What can I do to tell A2 to follow:
- content AND formating of another cell
- formating only of another cell


--
Additional information:
- I'm using Office XP
- I'm using Windows XP

Reference cell formats + content
 

Not possible using formulas


--

Regards,

Peo Sjoblom


"0-0 Wai Wai ^-^" wrote in message
...
Hi.
How can I tell one cell to follow content AND/OR formating of another
cell?
Here's an example:

A1:
=I am the <bbest!</b (<b...</b means bold letters)

A2:
=A1
Returns: =I am the best! (without bold)

What can I do to tell A2 to follow:
- content AND formating of another cell
- formating only of another cell


--
Additional information:
- I'm using Office XP
- I'm using Windows XP

Reference cell formats + content
 

you can copy and then paste special
--
paul
remove nospam for email addy!



"Peo Sjoblom" wrote:

Not possible using formulas


--

Regards,

Peo Sjoblom


"0-0 Wai Wai ^-^" wrote in message
...
Hi.
How can I tell one cell to follow content AND/OR formating of another
cell?
Here's an example:

A1:
=I am the <bbest!</b (<b...</b means bold letters)

A2:
=A1
Returns: =I am the best! (without bold)

What can I do to tell A2 to follow:
- content AND formating of another cell
- formating only of another cell


--
Additional information:
- I'm using Office XP
- I'm using Windows XP

Reference cell formats + content
 

How about by Marco or creating a custom formula?

"Peo Sjoblom" ¦b¶l¥ó
¤¤¼¶¼g...
Not possible using formulas


--

Regards,

Peo Sjoblom


"0-0 Wai Wai ^-^" wrote in message
...
Hi.
How can I tell one cell to follow content AND/OR formating of another
cell?
Here's an example:

A1:
=I am the <bbest!</b (<b...</b means bold letters)

A2:
=A1
Returns: =I am the best! (without bold)

What can I do to tell A2 to follow:
- content AND formating of another cell
- formating only of another cell


--
Additional information:
- I'm using Office XP
- I'm using Windows XP

Reference cell formats + content
 

Thanks for your idea.
But this could not maintain a dynamic link between 2 cells (ie when one cell
changes, another cell will not change)

"paul" ¦b¶l¥ó
¤¤¼¶¼g...
you can copy and then paste special
--
paul
remove nospam for email addy!



"Peo Sjoblom" wrote:

Not possible using formulas


--

Regards,

Peo Sjoblom


"0-0 Wai Wai ^-^" wrote in message
...
Hi.
How can I tell one cell to follow content AND/OR formating of another
cell?
Here's an example:

A1:
=I am the <bbest!</b (<b...</b means bold letters)

A2:
=A1
Returns: =I am the best! (without bold)

What can I do to tell A2 to follow:
- content AND formating of another cell
- formating only of another cell


--
Additional information:
- I'm using Office XP
- I'm using Windows XP