Any new tricks to help with this?

I have seen a couple of macro's floating about the web, but they are mainly for 2003.

One quick and easy solution is to copy and paste into Word, and then copy it back, which works fairly well. But it's a bit of a hack, and would like a tidier solution, maybe even some VBA I can put at the end of the macro?

Can't beleive there isn't a button in Excel for this!