I have an Excel file with book information in it and another folder with the book cover and fly photos. I would like to Hyperlink from a cell in the Excel file to the cover photo or fly photo – easy I know :- =HYPERLINK(“Book Photos\Book Name.jpg”,”Click for Photo”) But I have hundreds of them! Is there a way to go to Cell A of the Row, extract the name, add .jpg to that name and then insert it into the first part of the Hyperlink formula? And automatically do it to all the other Rows??

How are the photos named? If it's something like: Photo01.jpg Photo02.jpg Photo03.jpg You could simply put the word Photo in Cell A1 then start your numbering in Cell B1 and add the text string .jpg in Cell C1 Then combine them all in D1 with your =HYPERLINK() function. A lot is going to depend on how you named your photos. MIKE http://www.skeptic.com/

H Mike, The name in column A is the same as the photo name minus the .jpg extension. Column B is the authors name, C publisher, D Shelf, etc. So Cell A would be Of Mice and Men, The photos name is Of Mice and Men.jpg

If the name of the photo is in Cell A1, then In an empty cell like AA1 you would put the formula: =A1&".jpg" You now have your photo name with the .jpg extension. To actually view the photo you need to enter the complete path to the directory where that photo resides, something like: C:\Documents and Settings\Owner\My Documents\My Pictures\ Then in an empty cell, like AB1 you can then put in a formula like: =HYPERLINK("C:\Documents and Settings\Owner\My Documents\My Pictures\"&AA1,"Click for Photo:") Just drag cells AA1 down as many photos as you have then drag down cell AB1 for as many photos. MIKE http://www.skeptic.com/

Since the hyperlink will need the path to the photo, you might try something like this: =HYPERLINK("C:\Documents and Settings\username\Desktop\"&A1&".jpg", "Click for Photo')

Thanks DerbyDad & Mike - Worked a treat, much obliged.