ExcelBanter - Cell to follow content AND/OR formating of another cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell to follow content AND/OR formating of another cell (https://www.excelbanter.com/excel-discussion-misc-queries/44381-cell-follow-content-formating-another-cell.html)

0-0 Wai Wai ^-^

Cell to follow content AND/OR formating of another cell

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

Mike

Paste Special

"0-0 Wai Wai ^-^" wrote:

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

All times are GMT +1. The time now is 01:10 PM.