In this tutorial, you will learn how to combine cells in Google Sheets
How To Combine Cells In Google Sheets
Quick Navigation
Merging cells is a great way to combine multiple pieces of data into a single cell. This can be helpful if you have a long list of data and you want to make it easier to read.
For example, let’s say you have a list of employee names, and you want to merge the first and last name into one cell. Or maybe you have a list of address information and you want to combine all these different fields into a single cell.
In this guide, we will show you different methods to combine the values of multiple cells in Google Sheets. We will also cover how to merge cells into a single cell.
How To Combine Cells In Google Sheets
Here’s how to combine cells in Google Sheets.
Step 1
We’ll first try merging multiple cells into a single large cell with a single value.
The first step is to select the range of cells you want to merge together.
In the example above, we want to add a year header that spans the range A1:F1.
Step 2
Select the option Format > Merge cells > Merge all.
Alternatively, you can find the same Merge all option in the toolbar.
Step 3
The selected range should now appear as a single cell. The newly merged cell will take the value of the top-left most cell in the selected range.
Step 4
What happens when instead of combining cells into a single cell, you want to combine different values into a single cell?
We can use Google Sheets functions to add two strings together in a new cell.
Step 5
You can use the CONCAT function to add two strings together.
In this example, we’ve concatenated the values in the first_name and last_name columns.
Step 6
However, you may also want to add a space or another character between these two strings.
We can use the CONCATENATE function. This function allows us to append three or more strings together.
Step 7
We’ll use the Fill Handle option to automatically fill out the rest of the column.
Step 8
We can also use the JOIN function to combine cells in Google Sheets. The user will need to specify a delimiter, or a character that will be used to separate a list of values.
In the example above, we’ve used the JOIN function to create a string that combines the values in columns E to G. Our first argument also specifies the function to use an empty space to separate each value.
Summary
This guide should be everything you need to combine cells in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.