Concatenate in side an arrayformula with google sheets

by Roger Morris   Last Updated January 10, 2018 23:03 PM

I want to concatenate column A to the end of a url for every row A isn't null. This is just adding A:2 to the end over and over any ideas?

=ARRAYFORMULA(IF(ISBLANK(A2:A),"",CONCATENATE("http://www.somesite.com/folder/",A2)))

screenshot of google sheets with results from formula in question



Related Questions


Excel function: IF, AND, ISDATE, THEN

Updated August 15, 2018 05:03 AM



Counting cells with a certain background?

Updated January 25, 2018 03:03 AM

Get day from date, Google Sheets

Updated January 29, 2018 15:03 PM