Formulas > =CONCAT()
How To Use CONCAT() Function in Google Sheets
Description
How To Actually Use CONCAT() in Sheets
CONCAT(value1, value2)
Try CONCAT yourself
In cells A1 and A2, enter two different text values. In cell B1, write a formula that concatenates the values from A1 and A2 together.
Hints (2)
-
Remember to reference both cells in your formula.
-
You can use CONCAT to join text without any separator.
9 Better Sheets Tutorials
Build a Domain Grader
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.
ARRAYFORMULA()
CONCAT()
COUNTA()
COUNTIF()
LEN()
+1 more
Make Your Lists Spicy Hot in Google Sheets
Create fun funky bullet points to get your point across better. Put emojis in your sheets to bring them to life.
CONCAT()
ROW()
4 Ways to Make a New Spreadsheet
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.
CONCAT()
Find Hundreds of Available Domains From Keywords with Concat and Array Formula
Build a list of domains you can buy right now. Easily check if the domain you want is still available.
ARRAYFORMULA()
CONCAT()
IF()
ISBLANK()
Adding Number and dot to rank or order lists
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
CONCAT()
ROW()
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!
CONCAT()
CONCATENATE()
JOIN()
Create a Course Outline in Google Sheets
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.
CONCAT()
CONCATENATE()
COUNTA()
COUNTIF()
IF()
+4 more
What is this Ampersand Doing in Google Sheets?
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.
Do you know why this is so cool? It can replace an entire vlookup chart I've been making for years.
CONCAT()
DATE()
MONTH()
VALUE()
Creating a Custom URL Link for Your Spreadsheet
Create an apps script function that gets the url of your spreadsheet into a cell.
CONCAT()
HYPERLINK()
Learn more about the CONCAT() formula:
Generate a CONCAT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses CONCAT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a CONCAT() formula