Google Sheets: How to Merge Columns Without Losing Data

To combine values from columns, put the result in a new column: with a first name in A2 and a last name in B2, enter =A2&" "&B2 to return a full name with a space between the values. If you mean joining cells visually, select them and choose Format > Merge cells; that changes the layout, not the contents.

What merging columns can mean in Google Sheets

People use “merge columns” to describe two different tasks. One is combining the text or other values from separate columns into a single result, such as turning first and last names into a full name. The other is merging spreadsheet cells so that a group of cells becomes one larger cell, often for a heading. The methods are different, and choosing the wrong one can cause lost data or a table that is harder to sort.

For a list of records, such as customer names, addresses, or product details, combine the contents with a formula. The source values remain in their original columns, and the result can be filled down for every row. For a title spanning several columns, merge cells using the Format menu. Merged cells are usually for presentation rather than storing or organizing data.

Combine contents: join values into a new column with a formula.
Merge cells: make a selected group of cells display as one larger cell.
Move data: if the goal is to place a column beside another one, cut and paste it; merging is not a way to rearrange columns.

Merge cells using the Format menu

In Google Sheets in a web browser, select the range of adjacent cells you want to merge, then choose Format > Merge cells. Select the merge option that matches the shape of the selection:

Merge all combines the entire selected range into one cell.
Merge horizontally merges cells across each selected row. For example, selecting A1:C3 applies a horizontal merge separately to each of the three rows.
Merge vertically merges cells down each selected column.

The selected cells need to form a continuous range. If you select multiple cells that are not adjacent, the merge command may be unavailable. After a merge, the result is aligned according to the selected range and the sheet’s formatting settings. To reverse it, select the merged cell or range and use Format > Merge cells > Unmerge.

Before merging, check every cell in the selection. Google Sheets keeps the value from the upper-left cell of the selected range and discards values in the other cells; it does not concatenate them. If the selected range contains several names, for example, merging it will not create a name made from all of them. Copy the data elsewhere or use a combining formula first if those values matter.

Combine two columns with a formula

A formula is generally the safest way to combine columns of data because it leaves the original columns intact. With first names in A2 and last names in B2, enter this in C2:

=A2&" "&B2

If A2 contains Maya and B2 contains Chen, the result is Maya Chen. The ampersand joins values, and the quoted space inserts a separator. Without that space, the result would be MayaChen. You can use another separator, such as a comma and a space, by changing the text between the quotation marks.

To apply the formula to more rows, select C2 and drag the small square at the lower-right corner of the cell downward, or copy C2 and paste it into the destination rows. Sheets adjusts the row references as the formula fills down: the next row uses A3 and B3, then A4 and B4, and so on. If the sheet is updated later, the formula results update too.

For a one-time combined list, copy the formula results and use Edit > Paste special > Values only in the destination. This replaces formulas with their current displayed values. Keep a copy of the source columns until you have checked the results, especially if the data is important.

Join several columns and handle blank cells

When you need to join more than two cells, TEXTJOIN can insert a separator and optionally skip empty cells. With a city in A2, a region in B2, and a postal code in C2, enter:

=TEXTJOIN(", ",TRUE,A2:C2)

If the cells contain Portland, Oregon, and 97205, the result is Portland, Oregon, 97205. The first argument supplies the delimiter, the second tells Sheets to ignore empty cells, and the final argument identifies the range to join. If B2 is blank, the formula leaves out that empty value rather than producing an extra delimiter for it.

For a simple two-cell combination, the ampersand formula is often easier to read. For several fields or data that may contain blanks, TEXTJOIN is more flexible. If you set its second argument to FALSE, empty cells are not ignored, so the result can include repeated separators. Choose the setting based on whether blank fields should disappear or retain a position in the output.

Choose a separator and preserve useful formatting

The separator should make the combined value readable and unambiguous. A space suits first and last names; a comma and space can suit a city and state; a hyphen may suit a code whose parts are conventionally separated. Avoid adding a separator automatically if some source values already contain punctuation or if the combined field will be imported into another system with strict formatting rules.

Dates and numbers can need special attention. A formula that joins a date cell to text may show the date as a number rather than in the familiar date format, because spreadsheets store dates as numeric values. For example, with an event name in A2 and a date in B2, use =A2&" "&TEXT(B2,"yyyy-mm-dd") if you want the result to include a date formatted as year-month-day. Choose a format that suits the audience and the next use of the data.

Similarly, joining numeric values into text produces a text result, not a number that can be summed as though it were still in its original numeric column. Keep the source values separate when you need to calculate with them. Combined text is useful for labels, reports, and exports, but it is not a replacement for well-structured source data.

How to choose between formulas and merged cells

Use formulas when each row represents a record and you want the contents of multiple fields in one output field. Examples include full names, address labels, or a product code made from several parts. A formula maintains a clear relationship to the source values and is easier to copy, recalculate, or revise than manually retyping the combined text.

Use cell merging sparingly for visual layout, such as a centered report title over several columns. Do not merge cells inside a data table just to make entries look centered across columns. Merged cells can interfere with sorting, filtering, selecting consistent ranges, and pasting data, since the merged area no longer behaves like a regular grid of independent cells. For a heading that should appear centered across a range without merging, check whether horizontal alignment options meet the need; the data grid remains more flexible when cells stay separate.

Excel has similar concepts: its formulas can use the ampersand and TEXTJOIN, and it also offers a Merge Cells command. Menu names and locations differ between Excel and Google Sheets, so use the Sheets path above when working in a browser. In either program, merging cells is not the same as joining the values they contain.

Common problems and practical fixes

Some text disappeared after a merge: a merge retains only the upper-left cell’s value in the selection. Undo immediately with Edit > Undo if possible, or restore the source data from a copy or version history.
The combined result has no space: add a quoted space between the cell references, as in the example formula, or use another delimiter that suits the data.
Blank source cells create awkward punctuation: use TEXTJOIN with its ignore-empty argument set to TRUE, or design the formula to account for the specific blank pattern.
The formula appears as text: check that the cell is not formatted as plain text and that the entry begins with an equals sign. Re-enter the formula after correcting the cell format if needed.
The merged option is unavailable: check that the selection is a contiguous range and that the sheet is not protected in a way that prevents the edit.
A date or number looks different after joining: format it explicitly with TEXT before combining, or keep it in a separate column for calculations.

For a large or shared sheet, make a copy before changing its structure. A quick check of a few output rows can catch missing separators, blank-field surprises, or unexpected date formatting before the result is reused or shared.

A safe workflow for combining columns

For a dependable result, keep the source information and output separate until the combined values are checked. A practical sequence is:

Identify whether you need a visual heading or one combined value per row.
If combining values, add a new output column and write a formula for the first data row.
Check examples with complete and blank source cells, plus any dates or numbers that need a format.
Fill the formula down and review the output near the top, middle, and bottom of the list.
Keep the formula if the result should update, or paste values only if you need a fixed text result.
If merging cells for layout, confirm that any non-upper-left contents have been saved before using the merge command.

This workflow avoids the most common misunderstanding: the merge command changes the cell layout, while formulas create a combined value. Keeping those operations separate makes later edits and troubleshooting much easier.

Frequently Asked Questions

Does Google Sheets merge the text in selected cells?

No. Merging cells changes the layout and keeps the upper-left cell’s contents; values in the other selected cells are discarded. Use a formula such as an ampersand expression or TEXTJOIN to combine text.

How do I merge two columns without losing data?

Do not use Merge cells to combine the values. Put a formula in a new column, such as =A2&" "&B2 when the two values are in A2 and B2, then fill it down and check the results before removing anything from the source columns.

Can I merge cells across each row at once?

Yes. Select the rectangular range and choose Format > Merge cells > Merge horizontally. Sheets merges each selected row horizontally, retaining the value in the leftmost cell of each row and discarding other values within that row’s merged selection.

How do I undo a merge in Google Sheets?

Select the merged cell or range and choose Format > Merge cells > Unmerge. Unmerging restores separate cells, but it does not bring back values discarded when they were first merged; use Undo, a backup, or version history to recover those values.

Can I combine columns and keep the result updated?

Yes. Leave the formula in the output column. It recalculates when referenced source cells change. If you paste values only, the result becomes a fixed snapshot and will no longer update from the original columns.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.