Image - URL

I have images on my google drive populated from Appsheet.
I generate daily reports on excel.

I want to get a link of the image (public link kind of thing) to be present in a column of the image. User clicks the link, image should be displayed.

I browsed through and shared the google drive folder to be available publicly. How can use this link in a excel file. Meaning, I have the public folder link now and also the file name is stored in a column, Can I merge these using Concatenate etc., to display the link in the excel (public URL)?


Just saw the links and looks like its working with CONCATENATE.
you may please mark this resolved.