I imagine this is laughably simple but I just don't know what to do. I have a column (A) of cells with strings in them and I want to simply prepend each string in every cell with a web address: A--------1| /foo/bar/2| /foo/foo/3| /foo/baz/...I want:A--------1| http://foo.com/foo/bar/2| http://foo.com/foo/foo/3| http://foo.com/foo/baz/...
How do I prepend a string to a column of cells in Google Spreadsheets?
google spreadsheets
You can do that with a formula, so that e.g. column B will display the URL:=http://foo.com & A1(the & is the string concatenation operator in Google Spreadsheets)Put this formula in B1, and copy-paste it to other cells in the B column.