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



Excluding negative values from summation

Updated November 16, 2017 14:03 PM