Appends strings to one another.

How To Use in Sheets

CONCATENATE(string1, [string2, ...])

External Links

Using Join, Concat, & Concatenate

Joining text strings in Google Sheets using Join(), Concat(), &, Concatenate()

13Better Sheets Tutorials


Learn how to use Formulas in Google Sheets. Use the Equal sign "=" to unlock a magical portal of over 500 functions and formulas. Learn one cool trick that even experts might not know about formulas.
Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.


Learn to create lead magnet or sellable worksheets for your business. Included are more topic ideas so you can take this template and run with it.
Great for counting writing sessions, or tweets you're writing.
Track your goals with a thermometer.
One more function beyond Concatenate and Join that is useful in so many different ways. Concat can be used to quickly create unique columns of data. But watch out for dates!