In this tutorial, you will learn how to combine text from two cells in Google Sheets.
How to Combine Text From Two Cells in Google Sheets
Quick Navigation
Sometimes you may need to combine text from two different cells in a spreadsheet. For example, you may have a first name and last name in separate columns, and you want to combine them into one column.
In this guide, we will show you a few different methods you can use to combine text from two different cells in Google Sheets.
We’ll cover how to use the “&” character to append text together. We will also explain how you can use the CONCAT, CONCATENATE, and JOIN functions to convert multiple string values into a single string.
How to Concatenate Text From Two Cells in Google Sheets
Here’s how to concatenate or merge text from two different cells in Google Sheets.
Step 1
First, select an empty cell to place our combined text.
Step 2
We’ll start by using the “&” character to append text from two different strings together.
Step 3
You may also use the CONCAT function to combine two strings into a single string.
Step 4
The CONCATENATE function is a more powerful function since it allows for two or more arguments.
Since the function accepts three arguments, we can add a space between both words.
Step 5
We can also use the JOIN function to output a string composed of all strings in a specified range.
The output of the JOIN function will have each string separated by a chosen delimiter or separator. In the example above, we’ve decided on using a comma to split each word.
The user can change the delimiter to a space character to add spaces between each word in a range.
Summary
This guide should be everything you need to combine text from two cells in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.