How To Merge Cells In Google Sheets Without Losing Data

Last Updated on October 30, 2023 by Jake Sheridan

In this tutorial, you will learn how to merge cells in Google Sheets without losing data.

Google Sheets is a great way to keep track of data, but what happens when you need to merge cells?

Don’t worry, it’s easy to do and you won’t lose any of your data in the process.

In this tutorial, we’ll show you how to merge cells in Google Sheets without losing data.

Let’s get started!

How To Merge Cells In Google Sheets Without Losing Data

The easiest method is to use the CONCATENATE function. CONCATENATE is a verb that implies to unite or combine.

To merge the text from multiple cells into one cell in Excel, use the CONCATENATE function.

Once ready, we’ll get started by utilizing real-world examples to show you how to merge cells in Google Sheets without losing data.

Before using an example, you will need to understand how to use the CONCATENATE function.

=CONCATENATE(text1, [text2], ...)

  1. Text 1 is the fist item to join; and
  2. Text 2 is the second item to join and more if applicable.

Merge Cells without Losing Data

Before we begin we will need a group of data to be used to merge cells without losing data.

Step 1

First you need to have a clean and tidy group of data to work with.

Step 2

To merge the cells using CONCATENATE function, you will need to insert this formula into the cell =CONCATENATE(A2,” “,B2)

Step 3

Once you press Enter, the formula will return a merged cell.

Summary

That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to merge cells in Google Sheets without losing data. Want more? Check out all the Google Sheets Tutorials.