Share via

Cutting and Pasting text with subscripts and super scripts

Anonymous
2016-10-21T14:54:46+00:00

Many times I type readable versions of formulas need subscripts and super scripts. When I cut paste a variable with a subscript or superscript to a new cell, the subscript or superscript format is lost and I have to redo it. For example, if I cut and paste text from the cell below, it pastes as X2.

Can you help?

Mike

X^2^
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2016-10-21T15:20:44+00:00

    Copying from the formula bar (in edit mode) will result in just the text being copied. Formatting - even character by character formatting - is a property of the cell containing the text.

    If you want to copy and paste formatting, copy the cell itself, and then paste over another cell. If you then need to edit the text, do so in the new cell and the formatting will remain (as long as you don't delete the formatted characters).

    If copying part of a formatted string is something that you do often, then you may want to write a macro that will insert the characters and their formatting from one string to another.

    5 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest