I have a column with a bunch of links that need to be made into hyperlinks, how can

[mrholmandirect]

I have a column with a bunch of links that need to be made into hyperlinks, how can I do that all at once making them hyperlink to the sites in their fields without going down each field and double clicking and hitting enter? Thanks.

[martindwilson]

copy then run the macro here
http://support.microsoft.com/kb/271856