Excel Paste Formating

[Chuck S.]

I have voluminous text of math expressions filled with subscripts and
superscripts. I need to copy partial cell pieces into other cells containing
the same type expressions. However, when I properly highlight and then paste
into the destination cell portion it goes in as ordinary full size font
causing much work recreating the subscripting and superscripting. This
happens regardless of whether I copy within the same file or a different
Excel file. I thought there was a way to set options for copying and pasting
but cannot find it. I never dreamed Excel would be so limited when I spend
weeks creating the data. I chose Excel only to be able to Excel rows easily.
Chuck

 

[Gord Dibben]

When copying whole formatted cells you can set Excel up to match destination
or source formatting.

You have cells that have partial formatting......Super and Sub script of
some characters which I assume were individually formatted in the Formula
bar.

You are now trying to copy those characters from the formula bar to the
formula bar in another cell.

Can't be done.

VBA could possible do the trick.

Or download John Walkenbach's SuperSub add-in to facilitate formatting.

http://spreadsheetpage.com/index.php/file/superscript_subscript_formatting_add_in/


Gord Dibben MS Excel MVP

 

[Chuck S.]

Gord, Thank you for trying to help. This is my first experience with a
discussion group. I forgot to mention my version of Excel is likely 10 years
old running on Win XP-SP3. Concurrently, a recent Microsoft update disabled
my mouse and my cursor is acting virus like. I downloaded supersub.xla but
first received warning it would not open. Afterward, I was advised to change
security settings. It' is true I have been using what I guess is the formula
bar (pops up automatically) to edit what is really a text cell. This is
usually the only way I can edit now. I am desperate to get my job done
before attempting to repair my computer (a risk in my view). What I am doing
is developing about fifty very long formulas (in text) that sometimes wrap to
two lines on a landscape page in their individual cells. They are going to
get longer because I want to substitute smaller expressions from different
cells for various variables in the master formulas. The variable names are a
mixture of subscript, subscript, and regular text. I would like to simply
copy and paste as if I were in MS Word but cannot do it without losing
subscripting and superscripting
Chuck

 

[Gord Dibben]

Do all your copying/pasting in Word.

Then just copy over to Excel.

The formatting of Super and Sub scripts will be preserved when pasted into
Excel.

Tested in Office 2003 only.


Gord