I was lucky enough to come across this great Excel utility the other day and thought I should spread the word -

ASAP Utilities is a powerful Excel add-in that fills the gaps in Excel, and automates frequently used tasks. Since 1999 it has grown to become probably one of the world’s most popular add-ins for MS Excel.

ASAP Utilities is the product of many time-saving features and additions for Excel.
The extensive features are the result of years of experience and development, combined with the feedback from many respected users at different levels of experience. Particularly the feedback from users has been very important, and will continue to be important in further development.

It really has too many features to list here – but here are some web specific features I think you will find handy:-

# Clean information that is copied from websites…
# Extract hyperlinks…
# Activate hyperlinks (create from cell values)…
# Change all hyperlinks to =HYPERLINK() formulas
# Remove all hyperlinks in selected cells
# Decode all URL and HTML encoded text…
# Export selection as HTML table to clipboard…

Excel Add On - ASAP Ultilities

I strongly recommend checking out their website. ASAP Utilities – Excel Add On