How Do You Combine Cells in Google Sheets and Keep the Data?

There is a trap built into the first button most people reach for. You select two cells in Google Sheets, click Format > Merge cells, and a warning appears telling you that merging will keep only one value. Click through it and the other cell's contents are gone.

That is not a bug. Merge cells is a formatting tool — it exists to make one wide cell out of several, usually for a title row across the top of a table. It was never designed to combine *contents*. As Ablebits' guide to the feature puts it, "The standard Google Sheets Merge Cells tool keeps the content of the upper-left cell only," and "All other values get lost."

So if what you actually want is "Smith" and "Jane" to become "Jane Smith", you need a formula, not the merge button. The good news is that there are four ways to do it, they all take one line, and none of them touch your original data.

What is the fastest way to combine cells in Google Sheets without losing data?

Use the ampersand operator in a new cell:

`=A2 & " " & B2`

That reads as "the contents of A2, then a space, then the contents of B2". It is the shortest answer to the question and it is what most experienced Sheets users type by reflex.

The quotation marks around the space matter. Anything you want inserted literally — a space, a comma, a hyphen, the word "of" — goes inside quotes. Anything that is a cell reference does not. Mixing those up is the single most common reason a combine formula returns something that looks almost right but has no gaps between the words.

Three things to know before you go further:

• The result lives in a new cell. Your original columns stay exactly as they are, which is why this approach never loses data.
• The result is a formula, not text. If you delete column A, the combined cell breaks.
• If you want the combined values to become permanent text, copy the result column and use Edit > Paste special > Values only.

Not sure which of your pages are actually pulling traffic worth cleaning up data for? Get a free SEO audit and see which pages deserve the attention first.

Why does the Merge cells button delete your data?

Because merging and combining are two different operations that happen to sound alike in English.

Merging changes the grid. Three cells stop being three cells and become one rectangle. Since a cell can hold exactly one value, Sheets has to decide which of the three values survives — and it keeps the top-left one. Everything else is discarded, because there is nowhere left to put it.

Combining changes the content. The grid stays as it is; you create a new value somewhere else that contains the text from several cells joined together. Nothing is thrown away because nothing was overwritten.

When merging is the right tool

Merging is genuinely useful for presentation. A report header that spans columns A through F, a section label sitting above a block of rows, a cell that needs to be visually wide — those are all merge jobs, and using a formula for them would be the wrong answer.

When merging will cause you problems

Merged cells interfere with almost every structural operation in a spreadsheet. They break sorting, which is why they cause trouble the moment you try to alphabetize a Google Sheets range that contains them. They complicate filters. They confuse pivot tables, which expect one value per cell in a clean rectangle. And they make a sheet harder to reference in formulas, because a merged block only answers to its top-left address.

The practical rule: merge cells in the presentation layer, at the very top of a sheet or in a finished report. Never merge cells inside a data range you still intend to sort, filter, or calculate with.

How do you use CONCATENATE in Google Sheets?

CONCATENATE is the named function for the same job the ampersand does. Google's own documentation describes it simply as a function that "Appends strings to one another."

The syntax is:

`CONCATENATE(string1, [string2, ...])`

Google's documentation gives these sample usages:

`CONCATENATE("Welcome", " ", "to", " ", "Sheets!")`

`CONCATENATE(A1,A2,A3)`

`CONCATENATE(A2:B7)`

So to build a full name from two columns:

`=CONCATENATE(A2, " ", B2)`

That is identical in result to `=A2 & " " & B2`. Choose between them on readability. The ampersand is faster to type and easier to scan when you are combining two or three cells. CONCATENATE is clearer in a long formula that someone else will have to maintain, because the function name says what the formula is doing.

One detail worth knowing: Google notes that when you hand CONCATENATE a range that is more than one cell wide *and* more than one cell tall, "cell values are appended across rows rather than down columns." If you feed it a block and the output ordering surprises you, that is why.

Technical cleanups like this are easy. Knowing which pages are worth cleaning up is the hard part — run a free audit and start with the pages that already rank.

How do you combine a whole column of cells?

This is where the first two methods start to hurt. Typing `=A2 & " " & B2` is fine for one row. For six hundred rows with a changing separator and gaps in the data, you want TEXTJOIN.

Google describes TEXTJOIN as a function that "Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts." Its syntax is:

`TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])`

The three parameters, as Google defines them:

• delimiter — "A string, possibly empty, or a reference to a valid string. If empty, text will be simply concatenated."
• ignore_empty — "A boolean; if TRUE, empty cells selected in the text arguments won't be included in the result."
• text1 — "Any text item. This could be a string, or an array of strings in a range."

Google's sample usages are `TEXTJOIN(" ", TRUE, "hello", "world")` and `TEXTJOIN(", ", FALSE, A1:A5)`.

That `ignore_empty` parameter is the whole reason TEXTJOIN exists, and it is the reason to prefer it over the ampersand for real-world data. Set it to TRUE and blank cells are skipped entirely. Set it to FALSE, or use `=A2 & ", " & B2 & ", " & C2` on a row where B2 is empty, and you get a stranded delimiter: `Jane, , Smith`.

Combining down a column into one cell

To collapse an entire column into a single comma-separated string:

`=TEXTJOIN(", ", TRUE, A2:A200)`

That is the formula for building a tag list, an email recipient line, or a single-cell summary of a category column.

Combining across each row, for every row

To combine two columns row by row, all the way down, without dragging a formula:

`=ARRAYFORMULA(A2:A200 & " " & B2:B200)`

ARRAYFORMULA applies the operation to every row in the range at once. Ablebits' guide recommends exactly this pattern — `=ARRAYFORMULA(A2:A10&" "&B2:B10)` — for combining whole columns. One formula, one cell, and the whole column fills in.

JOIN, the fourth option

JOIN is the older sibling of TEXTJOIN. Google describes it as a function that "Concatenates the elements of one or more one-dimensional arrays using a specified delimiter." It takes a delimiter and a range, but it has no `ignore_empty` switch, so blanks come through as empty slots between delimiters. If TEXTJOIN is available — and it is, in every current version of Sheets — use TEXTJOIN instead.

Which method should you use?

A short decision list, in the order the question usually arises:

1. Two or three cells, one row, quick job → the ampersand: `=A2 & " " & B2`
2. Same thing, but in a formula others will maintain → `=CONCATENATE(A2, " ", B2)`
3. A range that contains blanks, or a whole column collapsed into one cell → `=TEXTJOIN(", ", TRUE, A2:A200)`
4. Row-by-row combination down hundreds of rows → `=ARRAYFORMULA(A2:A200 & " " & B2:B200)`
5. A wide title cell for presentation, with no content to preserve → Format > Merge cells is correct here

If you are unsure, TEXTJOIN with `ignore_empty` set to TRUE is the safest default. It handles the single-row case perfectly well, and it is the only one of the four that degrades gracefully when your data has holes in it.

What are the limits of these formulas?

Combining cells with a formula is reliable, but there are four things it will not do for you.

It does not reformat numbers or dates. When a date or a currency value goes through any of these functions, what comes out is the underlying value as text, not the formatted display string. A date shown as 04/10/2026 may well emerge as 46114. Wrap it in TEXT to control this: `=A2 & " — " & TEXT(B2, "dd/mm/yyyy")`.

The output is a formula, not a value. It recalculates whenever the source cells change, which is usually what you want, and it breaks when the source columns are deleted, which is usually not. Paste special as values only before you delete anything.

It does not deduplicate or clean. Trailing spaces in your source data come straight through into the combined result. If the source columns were pasted in from elsewhere, wrap each reference in TRIM: `=TRIM(A2) & " " & TRIM(B2)`.

It cannot un-merge data that merging already destroyed. This is the important one. If you have already clicked Merge cells and saved, the discarded values are not recoverable from the sheet itself. Your only route back is File > Version history > See version history, which will let you open the sheet as it was before the merge and copy the lost values out.

How does this compare with doing it the other way round?

The inverse operation — taking one cell and breaking it into several — is a different tool entirely. In Sheets that is Data > Split text to columns, or the SPLIT function, which Google describes as dividing "text around a specified character or string" and putting "each fragment into a separate cell in the row."

The two are worth knowing as a pair, because messy imported data usually needs both: split a combined "Name, City, Country" field into its parts, clean each part, then recombine the parts you actually want in the order you actually want them.

Against the alternatives outside Sheets, the honest comparison is short. Add-ons like Ablebits' Merge Values exist specifically to combine cells in place — writing the joined result back into the merged cell rather than into a new one — and if you need that exact behaviour repeatedly, an add-on earns its place. For everything else, the four built-in methods above are sufficient, free, and portable to anyone who opens your sheet.

Spreadsheet work is only worth doing if the pages it feeds are visible. Get a free SEO audit and find out which of yours are.

Final Thoughts

The whole confusion here comes down to one piece of unfortunate naming. "Merge cells" sounds like it should merge the contents of cells, and it does not — it merges the cells themselves and discards all but one value. Google even warns you before it does it.

Once you separate those two ideas, the rest is easy. Use Merge cells for layout. Use the ampersand, CONCATENATE, TEXTJOIN or ARRAYFORMULA for content. Reach for TEXTJOIN with `ignore_empty` set to TRUE when the data is real and therefore has gaps in it. And if you have already lost values to a merge, go straight to version history rather than trying to reconstruct them.

One last habit worth building: keep the combined column separate from the source columns rather than pasting over them. It costs one column of width and it means the next person to open the sheet — including you, in six months — can still see where the combined values came from. That is the same instinct that keeps merged cells out of ranges you need to sort alphabetically, and it saves the same kind of afternoon.

Clean data, clean rankings. Claim your free SEO audit and see what is holding your pages back.