Hi

I am in desperate need of help Please.
I am using Excel for Mac 2011 and have downloaded an .xls file from my supplier's website.
The first column is meant to contain a thumbnail of an image for each product in the list, but after downloading the file, each image shows a big red cross and states "The linked image cannot be displayed".
I don't necessarily need the image to display but I do need to extract the URL from each image and place it in another column.

I can do this one at a time by right clicking the image file and then selecting "Format Picture". Under "Alt Text" the URL is shown as the "Description".
I take it that the images are not hyperlinked otherwise the URL would be displayed under "Hyperlink" too when right clicking an image?
Due to the fact that there are literally hundreds of products on each downloaded list with multiple variations of each I cannot do this one at a time and need to be able to extract this url information ALLOT quicker.

Is there a function in excel or a macro I can create to allow me to do this?

I have attached a file for reference.

xlsmarchioNuwt.xl.xls

Thanks!
Alan