In column A I have a list of products using their stock codes. They take the form ajp00101, ajp00102 etc
I need to generate a column that contains the location of the image file. They need to take the form ajp.com/images/ajp00101.jpg etc
I cannot work out how to do this automatically. I used to know how to do this but since lockdown my brain seems to have turned to mush!