Better Sheets

Formulas > =CONCAT()

How to Use CONCAT() in Google Sheets

Description

Returns the concatenation of two values. Equivalent to the `&` operator.

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.

Your formula

Hints (2)

Locale Separator ,

Official Docs

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.

Beginner

CONCAT() ROW()

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.

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.

Beginner

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.

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

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.

Beginner

CONCAT()

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

Beginner

CONCAT() ROW()

Transcript-matched member videos for CONCAT(). Click through to watch.

Browse more tutorials

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge mu...

Beginner

CONCATENATE() JOIN()

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

There was a stories craze. Every app/platform/business was adding 24 hou...

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

Unlock these tutorials

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

How to Use CONCAT() in Google Sheets

Try CONCAT yourself

Build a Domain Grader

Make Your Lists Spicy Hot in Google Sheets

Find Hundreds of Available Domains From Keywords with Concat and Array Formula

Concat Because Concatenate is too hard to Remember!

Create a Course Outline in Google Sheets

What is this Ampersand Doing in Google Sheets?

Creating a Custom URL Link for Your Spreadsheet

4 Ways to Make a New Spreadsheet

Adding Number and dot to rank or order lists

More related tutorials

Calculate ROAS in Google Sheets

Hardest Formula: SumIF | Addition Based on Dates / Values

How to Merge Cells in Google Sheets

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.