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
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.
First, select an empty cell to place our combined text.
We’ll start by using the “&” character to append text from two different strings together.
You may also use the CONCAT function to combine two strings into a single string.
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.
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.
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.
More ways to use text in Google Sheets:
- Add Bullet Points
- Insert Text Box
- Insert Special Characters
- Insert Symbols
- Insert Page Break
- Center Text
- How To Make Text Fit In Cell
- Make Text Vertical
- Change Case
- View Page Breaks
- Line Break In Google Sheets
- How To Capitalize
- How To Wrap Text
- How To Indent
- Count Cells with Text
- Fit Text to Cell
- Checking if a Cell Contains a Substring
- TEXT Function
- SUMIF Cells If Contains Text
- Add Text To Formula
- Indent Text
- Change Text To All Caps
- Spell Check in Google Sheets
- How to Use Spell Check
- Insert a Bullet List
- Make a Numbered List
- Insert Bullet Points
- Add a New Line In Cell
- Add Multiple Lines In One Cell
- Wrap Text In Cell
- Superscript In Google Sheets
- Make A Degree Symbol
- SUBSTITUTE Function
- How To Alphabetize