Formulas > =CONCATENATE()

How to Use CONCATENATE() in Google Sheets

Description

Appends strings to one another.

How To Actually Use CONCATENATE() in Sheets

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

Try CONCATENATE yourself

In cells A1 and B1, you have first and last names respectively. Use the CONCATENATE formula in cell C1 to combine them into a full name, separated by a space.

Your formula

Hints (2)

Locale Separator ,

Official Docs

30 Better Sheets Tutorials

Countdown Blank Row

Great for counting writing sessions, or tweets you're writing.

Beginner

CONCATENATE() COUNTA()

How to Find Duplicates and create a Duplicate Detector

Create a duplicate detector with a few google sheet formulas.

Beginner

CONCATENATE() COUNTA() IF() MATCH() ROW() +1 more

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

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.

Advanced

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

Ben Asks: How Do I Add 1 Month?

Member Ben asks how to add 1 month to a date.

Intermediate

CONCATENATE() EDATE() TEXT() TODAY()

Sheet Stories / Video Notes + ADDED: Email Notifications

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!

Advanced

CONCATENATE() IF() INDEX()

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

Combine 2 Columns into 1: First Names and Last Names Together

Add together two columns data.

Beginner

ARRAYFORMULA() CONCATENATE()

Deep Inside Dark Habits Google Script

Go inside this apps script and sheet. See how it's designed and created.

ARRAYFORMULA() CONCATENATE() COUNTIF() FILTER() IFNA() +3 more

Build a Thermometer for Savings Goals

Track your goals with a thermometer.

Intermediate

CONCATENATE() IF() REPT() ROUND() SPLIT() +1 more

Create a Headline Generator

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.

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

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 hour lasting videos to their users accounts. Now you can do that with Google sheets.

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

Better Google Ad Writing Tool Sheet Makeover

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!

CONCATENATE() IF() ISBLANK() LEN()

Calculate ROAS in Google Sheets

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.

Intermediate

CONCATENATE() ROUND()

Building the Newsletter Geeks Virtual Mall

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

Advanced

CONCATENATE()

Most Common Errors and How To Handle Them in Google Sheets

Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0

Beginner

CONCATENATE() VLOOKUP()

How to Find Duplicates

Learn how to find duplicates with a simple formula in Google Sheets.

CONCATENATE() FILTER() IF() MATCH() ROW()

Create an Email Campaign Stats Calculator

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.

Advanced

CONCATENATE() ROUNDDOWN() UPPER()

Adding a Foodcourt to Doc's Virtual Mall | Sheet Improvement!

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

Advanced

CONCATENATE() HYPERLINK() IFERROR() INDEX()

Your First Formula

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.

Beginner

CONCATENATE() TRANSPOSE()

Prompt Parade

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.

Advanced

CONCATENATE() IF() ISBLANK() 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

Create a ChatGPT Cheat Sheet Spreadsheet

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

Intermediate

CONCATENATE() COUNTIF() IF() ISBLANK() LEN() +2 more

Duplicate Everything For Each Unique Value

Great use of SPINTAX. Get the Google Sheet Add-on; SPINTAX for free.

Intermediate

ARRAYFORMULA() CONCATENATE() JOIN() SPLIT()

YouTube Thumbnail A/B Test Results

Find out the results of YouTube Thumbnail A/B Tests with this YouTube Thumbnail Image hack we can do in Google Sheets.

Intermediate

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

Turn Headlines up to 11! - Update to Spintax Tool

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.

Intermediate

CONCATENATE() IF() JOIN() TRANSPOSE()

Every Possible Permutation - Solved with Spintax

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

Intermediate

CONCATENATE() IF() ISBLANK() JOIN() SPLIT()

How to Merge Cells in Google Sheets

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.

Beginner

CONCATENATE() JOIN()

OpenAI API Prompt with Array of Cells

Create a prompt to OpenAI with an array of cells

Intermediate

CONCATENATE()

Daily Writer's Word Count Tracker

Walk through creating an awesome automatic word count tracker that's easy to use and motivates the writer to keep going. With AI generated quotes from famous writers, along with simple formulas to generate states along the way.

Intermediate

CONCATENATE() COUNTIF() ROUND() SUM() TEXT() +1 more

Learn more about the CONCATENATE() formula:

Generate a CONCATENATE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses CONCATENATE(). 2 free AI generations, no signup. Members get unlimited use.

Generate a CONCATENATE() formula