Formulas > =CONCATENATE()

How To Use CONCATENATE() Function in Google Sheets


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 Actually Use CONCATENATE() in Sheets

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

29Better 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
Unlock the Power of Email Notifications! 📧 Dive into our latest video tutorial, where we show you step-by-step how to add email notifications to your Google Sheets. Stay ahead of the game, get instant updates, and keep your workflow seamless! Check it out now! 
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!
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.
Find out the results of YouTube Thumbnail A/B Tests with this YouTube Thumbnail Image hack we can do in Google Sheets.
Updated the Spintax tool to allow you to generate Spintax. Instead of having to come up with it all yourself, you can let AI generate the Spintax for you. Create variations on headlines, or phrases, or emails.
Someone asked about how to find all the permutations of text and I thought it was a perfect example to show you how to use Spintax add-on. Free for everyone.

→ Get Spintax
A master class on merging cells. How to merge two cells. How to merge multiple cells. How to merge horizontally, vertically, and why.  Create groups. Create headers. And how to merge automatically. Members get the sheet and the apps script down below.
Create a prompt to OpenAI with an array of cells

Learn more about the CONCATENATE() formula:

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!

Generate a CONCATENATE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.