81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Appends strings to one another.

Common questions about the CONCATENATE formula:
What is the CONCATENATE formula? It adds strings together.
How do I use the CONCATENATE formula?  use it inside of a Google Sheet cell.
What's the syntax for the CONCATENATE formula? CONCATENATE(string1, [string2, ...])

How can the CONCATENATE formula be used appropriately?
The CONCATENATE formula can be used to join two or more pieces of text together into a single value. It supports text, numbers, and cell references as arguments. It's useful to create full names from first, middle, and last names. It's useful to make whole addresses from different parts of an address.

How can the CONCATENATE formula be commonly mistyped?

What are some common ways the CONCATENATE formula is used inappropriately?
The CONCATENATE formula is sometimes used incorrectly as an alternative to the ARRAYFORMULA function. It can be used when you want to add characters between strings, but. the JOIN formula is better for that particular use case.

What are some common pitfalls when using the CONCATENATE formula?
The CONCATENATE formula can make formulas hard to read and understand. Someone who does not know the concatenate formula might look at your formulas and think it is wrong. It can be quite easy to mistakenly type the "CONCAT" formula instead of CONCATENATE.

What are common mistakes when using the CONCATENATE Formula?
Common mistakes include using unnecessary CONCATENATE formulas, not using cell references correctly, and mistyping the formula name. A user can easily think that the concatenate formula adds together numbers but in fact it actually just combines them as strings.

What are common misconceptions people might have with the CONCATENATE Formula?
Common misconceptions include expecting the concatenate formula to automatically retain the formatting of values and incorrectly thinking that it is the same as the JOIN or ARRAYFORMULA functions. Also your data can be wrong and you can't figure out what the formula did to it, but in fact the data was wrong the begin with. CONCATENATE cannot be a substitute for good Data Validation.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

There’s no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets

Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.

Your spreadsheets will never be the same again.

How To Use in Sheets

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

External Links

Using Join, Concat, & Concatenate

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

Five Frustrating Formulas and How to Conquer Them

Google Sheets formulas can be frustrating for a few reasons. First, you’re trying to remember what to use on the fly. Then you can't remember the name of a formula. If you do figure out the name, you can't remember the syntax. Then you don't know the proper way to write the data. FRUSTRATING!

23Better Sheets Tutorials

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Create an epic writing tool to generate text from AI with a parade of prompts. A list of prompts you create and write that can be used over and over again. Or use this template to create your own workbook to sell a sheet of your own prompts.
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.


Walk through step-by-step going from a blank sheet to an AI powered prompt engineering cheat sheet of a spreadsheet.

Watch the Upgrade to GPT-4 video to see the differences between GPT-3 and GPT-4 Apps Script

Wanted to share with members this course outline I am using for my own course making process. I outlined the course then added a bunch of cool little stats to help see my progress and keep me on a certain pace of video creation. 
Got an amazing tool from Inside Google Ads course by Jyll. She shares this tool, and I went for 30 minutes reviewing it, improving it, and redesigning it. Hope members can learn from this video. Jyll graciously allows me to share this sheet with members only!
Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.
Revolutionary Method to Manage Your Video Stories! Learn how to delete old videos in just 24 hours. Keep your content fresh and engaging. Click here for the ultimate guide. 
Go inside this apps script and sheet. See how it's designed and created.
Member Ben asks how to add 1 month to a date.
Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0
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.


A fun way to make a sheet look like a mall.


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!
Learn how to find duplicates with a simple formula in Google Sheets.


Create a duplicate detector with a few google sheet formulas.
There was a stories craze. Every app/platform/business was adding 24 hour lasting videos to their users accounts. Now you can do that with Google sheets.


We're gonna create another virtual mall, and in this one we're gonna make it for newsletters


Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.