Combine Two Columns in Google Sheets: Formulas and More

To combine the contents of two columns into one, enter a formula such as =A2&" "&B2 in an empty cell, then fill it down; with “Maya” in A2 and “Chen” in B2, the result is “Maya Chen.” If you mean physically merge two cells into one, use Format > Merge cells instead—but that does not join their text and can discard content.

What “combine two columns” can mean

People use “combine” for two different spreadsheet tasks. The first is to join the values from matching rows into a new value—for example, putting a first name and surname together, or joining a city and state. A formula does this while leaving the original columns intact. The second is to merge cells so they occupy one wider cell, often for a heading. That changes the cell layout, not the text inside it.

A third possibility is stacking one column’s list beneath another column’s list. That is different again: it combines two lists into one longer list rather than pairing row 2 with row 2, row 3 with row 3, and so on. Decide which result you need before choosing a method. If you need to keep both original data and create a combined value, a formula in a separate column is usually the safest starting point.

Join matching rows with a formula

For a simple combination, use the ampersand operator, which joins text values and separators. With first names in A2:A and surnames in B2:B, enter this in C2: =A2&" "&B2. If A2 contains Maya and B2 contains Chen, C2 displays Maya Chen. The space inside the quotation marks is a literal separator; without it, the result would be MayaChen.

Choose a separator that makes sense for the data. With a product code in A2 and a size in B2, the formula =A2&" - "&B2 inserts a spaced hyphen. With a street name and unit number, a comma or a space may be more readable. The separator is part of the formula, so you can change it without changing the source cells.

After entering the formula in the first output row, fill it down for the remaining records. Select the formula cell and drag its small fill handle at the lower-right corner down the column, or copy the cell and paste it into the needed rows. Relative references adjust as the formula moves: the next row uses A3 and B3, then A4 and B4. Put the output in a separate, empty column so it does not overwrite either source column.

Choose a separator and handle blank cells

If one or both cells may be empty, a basic formula can leave an unwanted space or punctuation mark. Google Sheets’ TEXTJOIN function can ignore empty cells. With values in A2 and B2 and a space as the separator, enter =TEXTJOIN(" ",TRUE,A2,B2). If A2 is Maya and B2 is blank, the result is Maya rather than a name with an extra trailing space. If both cells are blank, the result is blank.

The second argument, TRUE, tells TEXTJOIN to skip empty values. For a comma-separated pair, use a comma and a space as the separator: =TEXTJOIN(", ",TRUE,A2,B2). With A2 containing “Portland” and B2 containing “Oregon,” the output is “Portland, Oregon.” This is useful when some rows have a missing middle name, apartment number, or other optional field.

Be aware that a cell containing a formula that returns an empty string is not always treated exactly like a truly empty cell in every context. Check a few representative rows if your source data is generated by formulas. Also decide what should happen when only one field is present: skipping the blank is often right, but a fixed label or a different separator may be more suitable for your records.

Control number and date formatting

When you join a number or date with text, the result becomes text, and its appearance may not match the way the source cell is formatted. For example, a date that appears as 3 November 2026 in a cell might not retain that display style automatically in a concatenated result. If the date in B2 is an actual date and A2 contains “Due:”, use =A2&" "&TEXT(B2,"yyyy-mm-dd") to produce “Due: 2026-11-03.” The TEXT function’s format pattern controls how the date is written in the combined text.

The same idea applies to numbers. If you need a currency symbol, fixed decimal places, or leading zeroes, format the value deliberately rather than assuming the source cell’s visual formatting will carry over. For instance, identifiers such as 007 may be stored as the number 7; joining the value will not recreate the lost zeroes unless the value is stored as text or formatted in the formula. Keep numeric source values numeric in their original columns when they are used for calculations, and create a separate text result for display.

Combine entire columns and preserve the result

For a modest table, filling a formula down is straightforward and lets you check the output as you go. For a long dataset, ensure the formula covers every row that contains data, including new rows added later. An output formula can be copied down farther than the current data, but doing so may create many blank-looking results or make the sheet harder to manage. Keep headers in row 1 and begin the row-by-row formula in row 2.

A formula result changes when its source cells change. That is helpful for a live report, but not always what you want for a final export or a fixed record. To keep the combined text as it currently appears, copy the output cells, then choose Edit > Paste special > Values only. In Google Sheets, Ctrl+Shift+V is the Windows shortcut for pasting values only; on a Mac, use Command+Shift+V. Pasting values replaces formulas with their current results, so do it only after checking that the output is correct.

Consider keeping the source columns even after making a combined column. Separate values are easier to sort, filter, validate, and reuse. For example, keeping first and last names in distinct fields makes it possible to sort by surname or address a message by first name. A combined display column can be useful alongside them, but it should not automatically become the only copy of the information.

Merge cells for layout, not for joining data

If your goal is a wide heading across two columns, select the cells you want to merge and choose Format > Merge cells, then select the appropriate merge option. For two adjacent cells in one row, Merge horizontally creates one wider cell. This is a formatting and layout operation; it does not concatenate the contents. Google Sheets keeps the value in the upper-left cell of a merged selection and may remove values from the other selected cells. Read any warning and make a copy of important data before proceeding.

Merged cells can also make a data table harder to sort, filter, or edit consistently, because a merged area does not behave like a normal set of independent cells. They are generally better suited to a title or visual heading than to ordinary records. If you need both values preserved, first combine them with a formula or copy them elsewhere, and only then consider merging cells for presentation.

Stack two lists instead of pairing rows

If by “combine columns” you mean place all entries from column A and then all entries from column B into one long list, do not use the row-by-row formula above: that pairs values across the same rows. For a short list, copy the values from the second column and paste them below the last value in the first. Check for blank rows and duplicate entries if those matter to the result.

For a larger list, the right method depends on whether you need a one-time result or a list that updates as source data changes. A manual copy-and-paste is simple and stable, while formulas can make a derived list update automatically but require careful handling of empty cells and headers. Google Sheets and Excel have different function availability across versions, so do not assume a formula found in an Excel-only guide will work in Sheets. For routine data management, keeping source lists separate and making a clearly labeled combined output is often easier to audit.

Common problems and how to fix them

The formula appears as text: Make sure the cell is not being treated as plain text, and that the entry begins with an equals sign. Re-enter the formula after setting the cell to an appropriate automatic format if needed.
The output has no space: Add the separator between the references, such as " " for a space or ", " for comma-space. Text inside quotation marks is included literally.
Rows show the wrong pairing: Check that both source references point to the intended row. A2 should normally be joined with B2, not B3.
Some values disappear after merging: Merging cells is not a text-combination operation. Undo immediately if possible, or restore the source from version history or a backup if needed.
A date or number looks different: Use TEXT to specify the output format, or keep the value in its own column and use the combined text only for display.
New rows are missing the result: Extend the formula to the new rows, or use a workflow that accounts for the expected data range. Check the last populated row before sharing or exporting.

Google Sheets and Excel differences

In Google Sheets in a web browser, the formula operator & and TEXTJOIN are convenient ways to combine cell contents. Excel also supports the ampersand operator and TEXTJOIN in current desktop versions, but its menus and interface are not identical: Excel’s cell-merging controls are on the Home tab, while the Google Sheets path described here is Format > Merge cells. Instructions for one program should not be followed blindly in the other.

One other distinction is worth keeping in mind: “merge cells” is a command in both spreadsheet programs, but its purpose is layout, not data consolidation. A formula-based output is more reversible and keeps the original values separate. If a workbook will be opened in different spreadsheet applications, use ordinary formulas and straightforward cell layouts where possible, then check the result in the application where it will be used.

Frequently Asked Questions

How do I combine two columns in Google Sheets without losing the originals?
Put a joining formula in a third, empty column—for example, =A2&" "&B2—and fill it down. The source columns remain unchanged, and you can later copy the results and use Edit > Paste special > Values only if you need fixed text.

How do I combine first and last names with a space?
With the first name in A2 and last name in B2, use =A2&" "&B2. For rows where one part may be blank, =TEXTJOIN(" ",TRUE,A2,B2) avoids adding a separator for an empty cell.

Does Merge cells combine the text from both cells?
No. Merge cells changes the layout. It does not join the text, and values other than the upper-left value may be removed from the merged selection. Use a formula when you need both pieces of text in one result.

Can I combine columns with a comma between the values?
Yes. With values in A2 and B2, use =A2&", "&B2, or use =TEXTJOIN(", ",TRUE,A2,B2) if blank cells should be skipped.

How can I keep the combined results from changing?
Copy the formula results, then paste them as values using Edit > Paste special > Values only. This removes the formulas and leaves their current displayed results, so confirm the output before replacing them.

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.