How to Join Two Columns in Google Sheets With a Formula

To join two columns in Google Sheets, enter a formula such as =A2&" "&B2 in an empty column, replacing A2 and B2 with the cells in your first row of data, then fill the formula down. The ampersands combine the cell contents, and the space between the quotation marks separates them. You can use a different separator or join the values without one.

This method combines the contents of cells while leaving the original columns intact. It is useful for putting first and last names together, building addresses, or creating a single label from two fields. The instructions below are for Google Sheets in a web browser. Excel also supports the ampersand approach, but menu details and some formula features may differ.

What You’ll Need

A Google Sheets spreadsheet with the two columns you want to join.
An empty column for the combined results. Leave room below its first cell so the formula can be filled down.
A clear idea of what should appear between the values, such as a space, comma, hyphen, or nothing.

Step-by-Step

Check how your data lines up. Look at the first row containing actual data in each column. For example, if first names are in column A and last names are in column B, and row 1 contains headings, your first data row is row 2. The formula should refer to cells from the same row so that each first name is paired with the corresponding last name.
Choose an empty results column. Click the first empty cell on the first data row, such as C2. Do not type the formula into either source column, because that would replace existing data. If the results column has a heading, you can label it something like Full name in C1.
Enter a joining formula. With first names in A2:A and last names in B2:B, enter =A2&" "&B2 in C2. The space inside the quotation marks is the separator. For example, if A2 contains Maya and B2 contains Chen, the result in C2 is Maya Chen. Press Enter to calculate it.
Choose a separator that fits your data. For an email-style identifier or code that should have no gap, remove the quoted space from the formula. For a comma and space between address parts, put a comma followed by a space between the quotation marks. Keep separators inside straight double quotation marks, and retain the ampersands that join the cell references and separator.
Fill the formula down the column. Select C2 again. Move the pointer to the small blue square at the bottom-right corner of the selected cell, called the fill handle, and drag it down to the last row of your data. You can also copy C2, select the destination cells below it, and paste. Sheets adjusts the row references as the formula is copied, so the next row uses A3 and B3, then A4 and B4, and so on.
Review the results against the source rows. Check the first few combined values and a few farther down the sheet. Confirm that each output combines values from the same row and that punctuation, spaces, and capitalization look right. If a result is wrong, check the references and the source cells in that row before filling the formula again.
Decide whether the results should stay linked. A formula result updates when either source cell changes. If you need fixed text instead, copy the completed results, then use Edit > Paste special > Values only to replace the formulas with their current displayed values. Keep the original columns until you have checked the pasted values.

There is also a function option. With first names in A2 and last names in B2, enter =TEXTJOIN(" ",TRUE,A2,B2) in C2; for Maya and Chen, it returns Maya Chen. The first argument sets the separator, and TRUE tells the function to ignore empty cells. This can be handy when some rows are missing a value. Fill it down using the same method. For a basic two-cell join, the ampersand formula is often quicker to read.

Common Mistakes

Using the wrong row references. A formula in C2 that refers to A3 and B3 combines the next row’s values, making the output appear shifted. Confirm that each referenced row matches the formula’s row.
Forgetting the separator’s quotation marks. Text you type directly into a formula, such as a space or comma, must be enclosed in straight double quotes. Without them, Sheets may show a formula error rather than a joined result.
Expecting joined content to overwrite the source cells. A formula creates a result in the cell where you enter it; it does not merge the two original columns into one. Use a separate results column, and only remove source data after you have confirmed you no longer need it.
Confusing joining data with merging cells. The toolbar’s merge-cell options combine the layout of selected cells; they do not reliably join and preserve both text values. Use a formula to combine contents. Merging cells can also make sorting and filtering more difficult.
Leaving unwanted spaces or punctuation. A formula that adds a space still adds it when one of the cells is empty. That may leave a leading or trailing gap. Inspect rows with blanks and choose a formula or separator that suits how your data is filled.
Overwriting the formula too soon. If you type into a results cell after filling the formula, you replace that row’s formula. If values should be static, use Paste special > Values only for the selected results range rather than typing over cells individually.

Tips

Choose separators deliberately. A single space usually works for names; a comma and space can separate parts of a location; and no separator may suit codes. Think about whether the combined value will be read by a person or used by another system.
Keep an untouched copy of the input columns. Formulas make it easy to revise the output if the source data changes. Even after converting results to values, retaining the originals can help you correct an error or change the separator later.
Use the fill handle for a short or medium list. For a long dataset, copying the formula and selecting the remaining destination range can be faster. After pasting, check the last row as well as the first so you know the fill covered the full list.
Consider missing values before selecting a function. The ampersand formula is simple but will still include its separator if a source cell is blank. TEXTJOIN can ignore empty cells when its second argument is TRUE, which can prevent an unnecessary separator in incomplete rows.
Do not delete source columns while formulas still depend on them. The joined formulas refer to those columns. If you plan to remove them, first copy the results and paste values only into the results range, then verify that the values remain correct.
Remember that the result is text. Joining values is intended to make a combined text string. If you combine numbers, the result may not behave like a number in later calculations. Keep the numeric source columns for calculations and use the joined output for display or identification.

Troubleshooting

The cell shows a formula error. Check that the formula begins with an equals sign, that each text separator is inside straight double quotation marks, and that parentheses are balanced if you used a function. In some spreadsheet locales, formulas use semicolons rather than commas between function arguments. If a TEXTJOIN formula rejects commas, check the spreadsheet’s locale and use the argument separator it expects. The ampersand version does not use function-argument separators.

The result appears blank or incomplete. Look at the referenced source cells directly. They may be empty, contain only spaces, or hold text that is not visible because of formatting or column width. Widen the source or result column to inspect the contents, and remove unwanted spaces from the source if necessary. Also check whether the formula points to the intended columns.

Every output repeats the same pair. The formula may contain absolute references, which use dollar signs to keep a row or column fixed when copied. For a normal row-by-row join, references such as A2 and B2 should adjust as you fill down. Edit the first formula to use the appropriate row-relative references, then fill it down again.

The formula text appears in the cell instead of a result. Make sure the cell is not formatted as plain text and that the formula starts with an equals sign. Change the cell format if needed, then re-enter the formula. A leading apostrophe can also make Sheets treat an entry as text; remove it if it was added accidentally.

Some rows have extra spaces or separators. Check for blank source cells and for spaces already included at the beginning or end of source text. You can clean the source data or switch to TEXTJOIN with its ignore-empty option when the separator should appear only between available values. Review several irregular rows before applying the change to the full column.

Frequently Asked Questions

Can I join two columns without a space?
Yes. Use the ampersand formula with only the two cell references and no quoted separator. For example, with values in A2 and B2 and the output in C2, enter =A2&B2. If A2 is ab and B2 is 123, the result is ab123.

How do I put a comma between the values?
Put a comma and a space inside the quoted separator. With the source values in A2 and B2 and the result in C2, enter =A2&", "&B2. If A2 contains Seattle and B2 contains Washington, the output is Seattle, Washington.

Will the combined result update if I edit either source cell?
Yes, as long as the result is still a formula and the referenced source cells remain in place. Sheets recalculates the joined text when a referenced value changes. If you pasted the output as values only, it is fixed and will not update.

Can I combine more than two columns?
Yes. Add more cell references and separators to an ampersand formula, or use TEXTJOIN to specify a separator and a list of cells or ranges. Check the result carefully when some fields are blank, because the chosen method affects whether empty fields leave extra separators.

Does joining columns delete or merge the original cells?
No. A formula displays a combined result in a separate cell and leaves the source cells as they were. If you want to remove the originals later, first save or copy the data you need and make sure the results have been pasted as values, not left as formulas that depend on those columns.

Can I use the same formula in Excel?
Yes. The ampersand method shown here also works in modern Excel. Google Sheets menu labels and some functions may differ from Excel, so follow the Google Sheets paths in this guide when working in Sheets.

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.