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?

2 Answers 2


Always enclose string literals in double quotation marks.

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

This works OK for me:

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.