Adding one column to a string to dynamically create a URL in the next column

Question

I have a spreadsheet of product ID codes that I'd like to turn into links, and from everything I've read, the concat or concatenate functions in Google Sheets should work for that, but so far everything I try results in an error.

What I want to get:

Brand   Product Code    URL 
AP      X527W           http://example.com/search.php?Code=X527W    
AP      X522M           http://example.com/search.php?Code=X527W
AP      Y500M           http://example.com/search.php?Code=X527W

What actually happens, when I use the formula:

=concat('http://example.com/search.php?Code=', B2)

or =concatenate('http://example.com/search.php?Code=', B2)

or ='http://example.com/search.php?Code=' & B2

is #Error.

So how do I concatenate strings in Google Sheets?

score 23 · Accepted Answer · answered Jan 25 '12 at 06:48

23

Always enclose string literals in double quotation marks.

= "http://example.com/search.php?Code=" & B2

answered Jan 25 '12 at 06:48

MetaEd

3,132
2
21
23

score 4 · Answer 2 · edited Jan 05 '13 at 21:09

4

This works OK for me:

=concatenate("http://example.com/search.php?Code="; B2)

edited Jan 05 '13 at 21:09

Alex

22,820
12
83
106

answered Jan 05 '13 at 17:55

mitjajez

41
2

Adding one column to a string to dynamically create a URL in the next column

2 Answers2