CONCATENATE()

Description

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()

Google Docs Help

13Better Sheets Tutorials

1

FREE

Your First Formula
Beginner
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.
Create an Email Campaign Stats Calculator
Advanced
Creating A Dark Mode Theme | Announcing Dark Habits
IntermediateMost Popular
Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Sheet Stories / Video Notes + Clear 24 Hour Old Videos
Advanced
Deep Inside Dark Habits Google Script
Ben Asks: How Do I Add 1 Month?
Intermediate
Most Common Errors and How To Handle Them in Google Sheets
Beginner
Sheet Stories / Video Notes + ADDED: Email Notifications
Advanced

9

FREE

Create a Headline Generator
AdvancedMost Popular
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.

10

FREE

Adding a Foodcourt to Doc's Virtual Mall | Sheet Improvement!
Advanced
Countdown Blank Row
Beginner
Great for counting writing sessions, or tweets you're writing.
Build a Thermometer for Savings Goals
Intermediate
Track your goals with a thermometer.
Concat Because Concatenate is too hard to Remember!
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!