formula for creating url out of cell data

Hi there,
I am looking to create a formula where i use the data from one cell to create a url out of it. Example, cell contains "AbcD" and I want it to automatically generate in another cell the url "http://www.mysite.com/abcd.jpg", so the domain will be constant and the file name needs to appear in lowercase with .jpg extension. I had previously done this with a script but I want to use a formula if possible.

Thanks

thanks, this work, i had just 1 more issue I discovered. some of the data is hyphenated like "Ab-cD" so i need the formula to remove the "-" when creating the url with filename.

works great, thanks!