copy cell containing multiple fonts

5mugg13r

New Member
Joined
May 2, 2010
Messages
2
Excel 2000, WinXP

Does anyone know how to copy/paste a cell containing multiple fonts and keep it that way without having to reformat the newly pasted cell?

Example:

  • I have a cell with bulleted text (the bullets were created using a Wingdings font, the rest of the text is regular Arial)
    • I'd like to copy the cell to another sheet but pasting as Values generates all the content as Arial
    • If I then re-paste on top of the new cell as Paste Special>Formats, then it makes everything Wingdings.
Any idea on how to paste these cells and keep all the formatting?

Note: upgrading is not an option, recreating in Word not an option. Yes, I know this isn't what Excel should be used for but it's just how it is for this particular project.
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

starl

Administrator
Joined
Aug 16, 2002
Messages
5,985
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Why can't you just Paste normally? Why do a Paste Special?
 

5mugg13r

New Member
Joined
May 2, 2010
Messages
2
Wow. Feeling so much shame right now, can't even tell you. Thanks Starl. I suppose I'm so used to Edit>Paste Special that I've forgotten to start simple.

Let the flogging commence.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,578
Messages
5,770,949
Members
425,653
Latest member
UNSING

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top