Merge Columns in Google Sheets: Methods, Tips, and Fixes

To join the text or values in two Google Sheets columns, enter a formula such as =A2&" "&B2 in a new column and fill it down. To merge cells visually instead, select the cells and choose Format > Merge cells; that keeps only the top-left cell’s content, so use it carefully.

What “merge columns” means in Google Sheets

People use “merge columns” to describe two different jobs. One is combining information from separate cells—for example, putting a first name from column A beside a last name from column B. The other is joining cells into one larger cell for appearance, such as making a heading span several columns. Google Sheets treats these as different operations.

A formula combines cell contents while leaving the source columns separate. This is usually the right choice for names, addresses, labels, IDs, or data that you might later sort, filter, or export. The result can update automatically when the source values change.

The Merge cells command changes the layout of the selected cells. It does not join their text. If the selected cells contain several values, merging keeps the value in the top-left cell and removes the contents of the other cells. Use it mainly for presentation, such as a report title above a table, rather than to combine records.

Merge cells visually: the steps

In Google Sheets in a web browser, select the cells you want to turn into one cell. Then open Format > Merge cells and choose the option that matches the selection. You can also use the merge-cells button on the toolbar; its dropdown provides the available merge options.

Merge all combines the entire selected range into one cell.
Merge horizontally merges cells across each selected row, keeping separate merged cells on different rows.
Merge vertically merges cells down each selected column, keeping separate merged cells in different columns.
Unmerge returns a merged cell to its original grid of cells.

For example, selecting A1:C1 and choosing Merge all creates one wide cell for a heading. Selecting A2:C4 and choosing Merge horizontally creates one merged cell per row. If the selected range has a value in a cell other than the top-left cell of a merge group, Sheets may warn that other content will be discarded. Read that warning before confirming.

Choose the right merge option

The shape of the selection determines which option makes sense. For one heading that should stretch over several columns, select cells in a single row and use Merge all. For labels that should span several rows in one column, select a vertical range and merge vertically. If each row needs its own wide label, select a rectangular range and use Merge horizontally.

Be cautious when selecting a large rectangle. Merge all creates one cell for the whole selection, not one merged cell for every row. If your goal is to combine data row by row, a formula is safer. Merged cells can make a sheet harder to edit and can interfere with tasks that expect a regular grid, including sorting, filtering, and copying ranges. Keep the underlying data in unmerged cells whenever possible.

Combine two columns with a formula

To combine two cells in one row, place a formula in an empty column. Assuming the first name is in A2 and the last name is in B2, enter =A2&" "&B2 in C2. The ampersand joins values, and the quoted space inserts a space between them. If A2 contains “Maya” and B2 contains “Chen,” C2 displays “Maya Chen.”

To apply the formula to more rows, select C2 and drag the small fill handle at the lower-right corner of the cell down the column. Alternatively, copy C2, select the cells below it, and paste. Sheets adjusts the row references, so the next row uses A3 and B3, then A4 and B4, and so on. Keep the formula results in a separate column so the original data remains available.

For several cells or a range, Google Sheets also supports TEXTJOIN. Assuming values to combine are in A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) joins them with spaces and skips empty cells. Replace the space delimiter with a comma and a space, such as =TEXTJOIN(", ",TRUE,A2:C2), to produce a comma-separated result. This is useful for addresses or lists where some cells may be blank.

For a simple two-cell join, =CONCATENATE(A2," ",B2) is another option. It produces the same kind of result as the ampersand formula. If you want to join numbers as text, consider how they are formatted: a date or currency may appear as its underlying number in a concatenated result. Format the result as needed, or use a text-formatting formula when a particular display is required.

Handle blank cells and separators

Decide what should happen when one of the source cells is empty. The basic formula =A2&" "&B2 can leave an extra space if one value is blank. For ranges with multiple possible blanks, TEXTJOIN’s second argument, TRUE, tells Sheets to ignore empty cells. For example, if A2 is “Maya,” B2 is blank, and C2 is “Chen,” =TEXTJOIN(" ",TRUE,A2:C2) returns “Maya Chen” without a double space.

The delimiter is the text placed between values. Use a space for a full name, a comma and space for a readable list, or a hyphen for a code. Include punctuation inside the formula’s quoted text. If the data already contains spaces or punctuation, inspect a few results before filling down; a formula can join values exactly as supplied, but it cannot determine which punctuation is correct for your use.

For an entire column, first test the formula on a few rows. You can then fill it down as far as needed. An array formula can automate a larger range, but it may populate many cells and needs room to expand. A basic row formula is often easier to understand and maintain, especially in a shared sheet.

Keep the combined results as values

A formula result is linked to its source cells. If you change A2 or B2, the combined value changes too. If you need a fixed snapshot—for example, before deleting or replacing the original columns—copy the formula results and paste them as values into a suitable destination. Use Edit > Paste special > Values only in Sheets. Check the pasted results before removing the source data.

This differs from visually merging cells: a merged cell is a layout change, while a formula creates a new value. Neither operation automatically deletes the original columns when you use a separate output column. Keeping the sources until you have checked the output makes mistakes easier to correct.

Common problems and how to fix them

Only one value remains after merging. That is expected behavior for a visual merge. Undo immediately if possible, or restore the discarded values from version history or a copy; use a formula instead when all values matter.
The merged option is unavailable or behaves unexpectedly. Check that the selection is a valid range and that you are using the merge dropdown’s appropriate option. If a filter or protected range is involved, try working in an unfiltered, editable area or check the sheet’s permissions.
The joined text has no space. Add a delimiter between cell references, such as the quoted space in =A2&" "&B2.
There are unwanted spaces or punctuation. Use TEXTJOIN with a delimiter that fits the data, and check whether blank cells or existing spaces are part of the source values.
Sorting becomes awkward. Avoid merging cells inside the data table. Unmerge them where practical and use a formula column for combined labels; keep any merged title above, rather than within, the sortable table.

Alternatives to merging

If you are trying to put a value from one column after another, rather than place them side by side, copying and pasting may be enough. For instance, you can paste one column’s values into the empty cells below another column. Check for gaps and duplicates first, because pasting into occupied cells can overwrite information.

If you want to divide combined text back into separate columns, select the cells and choose Data > Split text to columns. Sheets can split at a detected separator or one you specify. This is useful for undoing a comma- or space-separated export, but it may split legitimate text unexpectedly—names and addresses do not always follow a consistent pattern—so review the preview and results.

For a polished heading without merging, you can leave the cells unmerged and center the heading in one cell, or place it in a cell above the table. This preserves the ordinary grid structure and is often more convenient for later edits. Choose a visual merge only when the layout benefit outweighs the extra care required around the merged range.

Frequently Asked Questions

Can I merge two columns in Google Sheets without losing data?
Not with the Merge cells command: it retains only the top-left cell’s content in each merged area. To preserve both values, combine them with a formula in a separate column, then check the results before changing or deleting the originals.

How do I combine first and last names in Google Sheets?
If the first name is in A2 and the last name is in B2, enter =A2&" "&B2 in another cell. Fill the formula down to combine the remaining rows. TEXTJOIN is helpful when there may be blank cells between name parts.

Can I merge cells in each row at the same time?
Yes. Select a rectangular range and choose Format > Merge cells > Merge horizontally. Sheets makes a separate merged cell across each selected row. This is a layout operation, not a way to join the text in those rows.

How do I undo a merge?
Select the merged cell and choose Format > Merge cells > Unmerge. Unmerging restores the cell grid, but it does not bring back values discarded when the cells were merged. Use Undo or recover an earlier version if you need those contents.

Does merging cells work the same way in Excel?
The general distinction is similar: a merge command changes the layout, while formulas combine values. However, the menus and available options differ between Excel and Google Sheets. The steps above are specifically for Sheets in a web browser.

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.