software

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

A1:
=I am the lt;bgt;best!lt;/bgt; (lt;bgt;...lt;/bgt; 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
Not possible using formulas--

Regards,

Peo Sjoblomquot;0-0 Wai Wai ^-^quot; gt; wrote in message
...
gt; Hi.
gt; How can I tell one cell to follow content AND/OR formating of another
cell?
gt; Here's an example:
gt;
gt; A1:
gt; =I am the lt;bgt;best!lt;/bgt; (lt;bgt;...lt;/bgt; means bold letters)
gt;
gt; A2:
gt; =A1
gt; Returns: =I am the best! (without bold)
gt;
gt; What can I do to tell A2 to follow:
gt; - content AND formating of another cell
gt; - formating only of another cell
gt;
gt;
gt; --
gt; Additional information:
gt; - I'm using Office XP
gt; - I'm using Windows XP
gt;
gt;
you can copy and then paste special
--
paul
remove nospam for email addy!
quot;Peo Sjoblomquot; wrote:

gt; Not possible using formulas
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt;
gt; quot;0-0 Wai Wai ^-^quot; gt; wrote in message
gt; ...
gt; gt; Hi.
gt; gt; How can I tell one cell to follow content AND/OR formating of another
gt; cell?
gt; gt; Here's an example:
gt; gt;
gt; gt; A1:
gt; gt; =I am the lt;bgt;best!lt;/bgt; (lt;bgt;...lt;/bgt; means bold letters)
gt; gt;
gt; gt; A2:
gt; gt; =A1
gt; gt; Returns: =I am the best! (without bold)
gt; gt;
gt; gt; What can I do to tell A2 to follow:
gt; gt; - content AND formating of another cell
gt; gt; - formating only of another cell
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Additional information:
gt; gt; - I'm using Office XP
gt; gt; - I'm using Windows XP
gt; gt;
gt; gt;
gt;
gt;
gt;

How about by Marco or creating a custom formula?

quot;Peo Sjoblomquot; gt; ¦b¶l¥ó¤¤¼¶¼g...
gt; Not possible using formulas
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt;
gt; quot;0-0 Wai Wai ^-^quot; gt; wrote in message
gt; ...
gt; gt; Hi.
gt; gt; How can I tell one cell to follow content AND/OR formating of another
gt; cell?
gt; gt; Here's an example:
gt; gt;
gt; gt; A1:
gt; gt; =I am the lt;bgt;best!lt;/bgt; (lt;bgt;...lt;/bgt; means bold letters)
gt; gt;
gt; gt; A2:
gt; gt; =A1
gt; gt; Returns: =I am the best! (without bold)
gt; gt;
gt; gt; What can I do to tell A2 to follow:
gt; gt; - content AND formating of another cell
gt; gt; - formating only of another cell
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Additional information:
gt; gt; - I'm using Office XP
gt; gt; - I'm using Windows XP
gt; gt;
gt; gt;
gt;
gt;
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)

quot;paulquot; gt; ¦b¶l¥ó
news
gt; you can copy and then paste special
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; Not possible using formulas
gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt;
gt; gt; quot;0-0 Wai Wai ^-^quot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi.
gt; gt; gt; How can I tell one cell to follow content AND/OR formating of another
gt; gt; cell?
gt; gt; gt; Here's an example:
gt; gt; gt;
gt; gt; gt; A1:
gt; gt; gt; =I am the lt;bgt;best!lt;/bgt; (lt;bgt;...lt;/bgt; means bold letters)
gt; gt; gt;
gt; gt; gt; A2:
gt; gt; gt; =A1
gt; gt; gt; Returns: =I am the best! (without bold)
gt; gt; gt;
gt; gt; gt; What can I do to tell A2 to follow:
gt; gt; gt; - content AND formating of another cell
gt; gt; gt; - formating only of another cell
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Additional information:
gt; gt; gt; - I'm using Office XP
gt; gt; gt; - I'm using Windows XP
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;