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