Help with a simple formula for a novice

Question

I am very new to Excel and need some help. all I need to do is to use an ID in the following hyperlink: http://www.wotnots.co.uk/property/images/property2402_image1.jpg The ID here is 2402. I want to change it to the ID number which is in the first column and is different on every row. I want to have the ID number to be the same as the number in the hyperlink. Can someone help a poor novice, please?

Answer 1

Here you go.

=Concatenate("http://www.wotnots.co.uk/property/images/property",$A1,"_image1.jpg ")

Answer 2

Try the following formula:

="http://www.wotnots.co.uk/property/images/property"&A1&"_image1.jpg"

Answer 3

I would use the HYPERLINK cell function to generate the link. For example:

Cell A2: 2402
Cell B2: =HYPERLINK("http://www. ... /property" & A2 & "_image1.jpg","Click to see ...")

You can then copy the formula into all of the following rows, and the reference to cell A2 will change to be relative to the current row.

This can also be generated dynamically using VBA code if necessary.