Search:

The only I could suggest is to break it down by category or type or however and Sort it that way.

With Paste Special, you can control what gets changed by what you have highlighted, so if you can...

If you use a spreadsheet program like Excel or Open Office you can do it real simple, its called Paste Special - I just learned about it.

In an empty cell (anywhere on that active sheet is fine)...