I have a library of flags online and would like to have a client-foolproof solution for adding flags.Right now my function looks like this:=image(http://www.website.com/flags/us.png, 3)But I would like to just write us and the let the functions add this before:=image(http://www.website.com/flags/And this after:.png, 3)is this even possible?
Automatically add values before and after Google spreadsheet
google spreadsheets
Yes, you can do it with function CONCATENATE to combine the strings. Assume the word us is in A1, you can add below forumla to B1,=IMAGE(CONCATENATE(http://www.website.com/flags/,A1,.png), 3)You can also use function CONCAT too, but it is less useful as it only accepts two strings as parameters.