Replace part of a link with text from a cell and capitalize

Hello,

I am using IMAGE formula to grab photos from a website

I would like to automatically replace part of the link with the text of a different cell and capitalize the letters.

Attached example file

Could you please help me out?

Thanks a lot!