Formula in text met sub and super font size resizing

[lord anubis]

Hi,

years back I did wrote a sneak/peek back document ( PDF ) and got a lot of formula's in there.

Now I want to use a lot, 25-30 or so of thhose in excel. I can copy paste from the PDF to excel. They are in good shape but are way to small. In PDF they are font size 12 but in excel they look like 6 or 8.
If I resize them with the font size popup menu, then they are all changed to one size. Definitely not wanted.
Instead of typing them again with all the sub/super, small and special character, I would love to know a way to get them resized in one go.

Any suggestions?

[kev_]

Try pasting to Notepad first and then copy/paste from Notepad to Excel

Or try pasting into Excel when cell is in edit mode

[lord anubis]

Thank you.

But that didn't work, because the type font size is then to small like I wrote. Resizing in Excel resizes all to the same size. ( Macos )

I did solve it by using Word, copy paste in there then resize then copy past into excel. The only thing is that I should do it the right size, because when I resize it a little bigger then everything is again one size.

So for now my 'solution' is to copy everything in a Word document object ( Insert-Object-Word ), keep it on a extra Tab and if I need tot resize the formula I do a open the object again and copy paste into Excel cell again.

I know everybody know this, but maybe a tip for the others.

[kev_]

Here are 2 other PasteSpecial options which may be easier
- which one works for you is dependent on how Excel interprets what is in the clipboard

PasteSpecial Match Destination.jpg

PasteSpecialText.jpg