Formulas > =CONCATENATE()
How to Use CONCATENATE() in Google Sheets
Description
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.
Hints (2)
-
Remember to include a space between the first and last names.
-
You can use quotation marks to add a space.
Better Sheets Tutorial
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.
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.
Combine 2 Columns into 1: First Names and Last Names Together
Add together two columns data.
OpenAI API Prompt with Array of Cells
Create a prompt to OpenAI with an array of cells
Countdown Blank Row
Great for counting writing sessions, or tweets you're writing.
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!
Ben Asks: How Do I Add 1 Month?
Member Ben asks how to add 1 month to a date.
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
Watch the Upgrade to GPT-4 video to see the differences between GPT-3 and GPT-4 Apps Script
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.
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.
How to Find Duplicates
Learn how to find duplicates with a simple formula in Google Sheets.
Creating A Dark Mode Theme | Announcing Dark Habits
Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Building the Newsletter Geeks Virtual Mall
We're gonna create another virtual mall, and in this one we're gonna make it for newsletters
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.
Deep Inside Dark Habits Google Script
Go inside this apps script and sheet. See how it's designed and created.
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
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.
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!
Adding a Foodcourt to Doc's Virtual Mall | Sheet Improvement!
A fun way to make a sheet look like a mall.
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.
Build a Thermometer for Savings Goals
Track your goals with a thermometer.
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!
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.
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.
Duplicate Everything For Each Unique Value
Great use of SPINTAX. Get the Google Sheet Add-on; SPINTAX for free.
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.
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
→ Get Spintax
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.
More related tutorials
Transcript-matched member videos for CONCATENATE(). Click through to watch.
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