How to insert text from column E to column R with URL added

Hi,
I am trying to figure out how to use the data in column E and insert that to column R with a url added to the text taken from column E. I have 3600 rows to repeat this on.

=HYPERLINK("https:// …  /mb2-upload/" & E4 & ".jpg")

fill the …gap with the obvious, and pull down

1 Like

That worked great, Thank you for your help.