Add "http://mysite.com" to words in cell

[jj33002]

A B
myname http://mysite.com/myname.jpg


I am trying to make a formula that I can put in column B to get this. I have a large list in column A and need column B to take name from A and look like this example.

I have tried a few but am striking out. Any help would be much appreciated.

Thanks in advance,
Josh

[jj33002]

Hold that thought. I may have just stumbled onto the answer!

I used
="http://mysite.com/img/"&C2&".jpg"
seems to be working. If anyone knows a better way, feel free to chime in, but it looks like this will work.

[FDibbins]

Good job, thats probably what I would have suggested

Please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol (see point 2 below)