i have copy pasted a table from a html document.

the data has been pasted perfectly.

the third column is a column of GIF image of an envelop, which is a link to a email address.

i need to extract this hyperlink to a different column on the same sheet.. is there any way to do this automatically? i have office 2000 and ASAP utilitues add in installed.

You need to extract the link or the data behind it? If you can do the steps manually, you can just record a macro and automate it.