"right click -> Copy As PlainText"? Office 2010 still doesn't ship with such a feature, and it's been a problem from the '90s!"
Have you used Office 2010? There are multiple options to pasting: Keep source formatting, merge formatting, and keep text only. The options in Excel are even greater.