Formulas > =CONCAT()

How To Use CONCAT() Function in Google Sheets


Returns the concatenation of two values. The same as the `&` operator. Combines two values into one string.

Common Questions About the CONCAT Formula:
1. What is the CONCAT formula? A formula that combines two values into one cell.
2. How do you use the CONCAT formula in Google Sheets?  Select two values and put the between parantheses, along with a comma.
3. What parameters does the CONCAT formula take? The CONCAT formula takes two values.

How can the CONCAT Formula be Used Appropriately?
The CONCAT formula can be used to combine the text of multiple cells or ranges into one text string.

How can the CONCAT Formula be Commonly Mistyped?
The most common mistyping of the CONCAT formula involves missing a parameter, such as a missing quote or comma. CONCAT can be mistyped as CONCATE, or CONCT, or CNCAT, or CNCT, or CONATEN, or CONCATEN, or CONAT, or CNCATEATE.

What are some common ways the CONCAT formula is used inappropriately?
The CONCAT formula can be used incorrectly when it is used to concatenate cells that contain numerical values, rather than text values. This can produce unpredictable results. And false results. Conatenating 2 and 2 results in 22, where as you probably wanted to add those numbers together. But there are instances in which you do want to combine two numbers together without adding them.

What are some common pitfalls when using the CONCAT formula?
Common pitfalls when using the CONCAT formula include attempting to use too many parameters, which can lead to an error. You might want to add together two numbers, but instead be concatenating them together. One issue might arise when you want to concatenate three numbers, and think that the CONCAT formula can take more than 2 values. You'll want to use CONCATENATE() instead.

What are common mistakes when using the CONCAT formula?
Common mistakes when using the CONCAT formula include attempting to concatenate cells that contain non-text values, such as numbers or formulas; forgetting to include all the necessary parameters; and forgetting to enclose text in quotation marks. You'll either get an error or no error in these cases.

What are Common Misconceptions People Might Have with the CONCAT Formula:
One common misconception about the CONCAT formula is that it only works with strings or text. However, the CONCAT formula can also be used to combine numerical values as well. But the concatenation might not be what you expect. You can still use the CONCATENATE() formula to combine two values. You don't necessarily have to use CONCAT()

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.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you. 

If you need to replace VLOOKUP, give INDEX/MATCH a try.

Better Sheets has got each key formula crucial to boost your Google Sheets skill

How To Actually Use CONCAT() in Sheets

CONCAT(value1, value2)

8Better Sheets Tutorials

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. 
Create fun funky bullet points to get your point across better. Put emojis in your sheets to bring them to life.
Here's four ways to make a new sheet. There's lots of reasons why you wanna know all of them. Makes you a more flexible, faster spreadsheeter.
Build a list of domains you can buy right now. Easily check if the domain you want is still available.
This is like one of those things that is incredibly frustrating about Google Sheets. I will tell you right now. It is the simplest, stupidest solution
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!
Create a way to grade the quality of a domain based on many different votes and inputs and qualities. Like measuring the length and ranking the results.
What is "&" doing in this formula? MONTH(A1&1)
Do you know why this is so cool? It can replace an entire vlookup chart I've been making for years.

Learn more about the CONCAT() formula:

Easily Make Rank Lists in Google Sheets

Make your lists more concise and easier to read by adding the one thing all lists needs...tacos, oh wait, no, I mean dots. As simple as 1. 2. 3. One of the most frustrating things with Google Docs the fact that you can't create number lists with dots...until now! A simple trick that will make your listicles seem more mystical!

Generate a CONCAT() 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. Free to try for non-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.