ExcelBanter - How copy a cell with mixed text (regular, bold, italic) with a fo.

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

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

- - How copy a cell with mixed text (regular, bold, italic) with a fo. (https://www.excelbanter.com/excel-discussion-misc-queries/249335-how-copy-cell-mixed-text-regular-bold-italic-fo.html)

Burkhard

How copy a cell with mixed text (regular, bold, italic) with a fo.

If I copy a cell with mixed text (regular, bold, italic) into a different
cell it shows exactly same mixed text.
However, if I copy it with a formula "=A1" then it shows regular text only.
How do I change that?

Pete_UK

How copy a cell with mixed text (regular, bold, italic) with afo.

You can't do it with a formula - you would need a macro.

Pete

On Nov 25, 10:40*am, Burkhard
wrote:
If I copy a cell with mixed text (regular, bold, italic) into a different
cell it shows exactly same mixed text.
However, if I copy it with a formula "=A1" then it shows regular text only.
How do I change that?

All times are GMT +1. The time now is 06:21 AM.