To join text from columns in Google Sheets, use =A2&" "&B2 to combine the values in A2 and B2 with a space between them. To combine several cells with a chosen delimiter while skipping blanks, use =TEXTJOIN(", ",TRUE,A2:C2). If by “join columns” you mean matching records from separate tables, use a lookup formula instead.
What joining columns means in Google Sheets
“Join columns” can describe two different spreadsheet tasks. The first is combining the contents of cells from the same row into one text value—for example, joining first and last names, or building a full address from street, city, and postal code columns. The second is matching rows in one table to corresponding rows in another table using a shared identifier, such as a product code or customer ID. The right method depends on which result you need.
For simple text combination, Google Sheets treats the result as a new value in a cell; it does not merge the original columns or alter their contents. You can fill a formula down to create a combined value for each row, or use an array formula to calculate many rows at once. For matching records, a lookup formula finds the row with the same key and returns a value from another column.
This distinction matters because the spreadsheet command Format > Merge cells is something else. It combines the selected cell area into a larger visual cell. It does not concatenate all the values, and it is not a way to match records between tables.
Combine two cells with the ampersand
The ampersand operator (&) is a direct way to concatenate, or join, cell contents. With a first name in A2 and a last name in B2, enter =A2&" "&B2 in C2. If A2 contains Ada and B2 contains Lovelace, the result is Ada Lovelace. The quoted space is a text value inserted between the cell contents; without it, the result would be AdaLovelace.
You can choose another separator or none at all. For example, a comma and a space are useful for a city-and-region label, while a hyphen may suit an inventory code. The formula can also include fixed text, such as a label before a value. Keep in mind that a separator is part of the output, so adding a space at the end of one cell and another at the beginning of the next can leave unwanted gaps.
With street number in A2 and street name in B2, the formula =A2&" "&B2 produces a readable address fragment such as 12 Main Street. The formula only combines the cells in that row. To apply it to the next record, fill or copy it down the result column; the relative references change to A3 and B3, then A4 and B4, and so on.
Use TEXTJOIN for several columns and optional blanks
TEXTJOIN is useful when a row has more than two parts or some cells may be empty. It takes a delimiter, a setting for whether to ignore empty cells, and the text or range to combine. With values in A2:C2, enter =TEXTJOIN(", ",TRUE,A2:C2). If the cells contain North, 14, and Active, the result is North, 14, Active. If B2 is blank, the formula skips it rather than producing an extra empty item between two commas.
The delimiter can be a space, comma, slash, or other text. For instance, a space is usually appropriate for a person’s name, while a comma-space works for a compact list. Set the second argument to FALSE if empty cells should still occupy a position in the joined result. That can be useful when empty positions have meaning, but it can also create repeated delimiters or blank-looking gaps.
TEXTJOIN can join an entire range, but for a row-by-row output you should select the cells from that row, such as A2:C2, and fill the formula down. A range such as A2:C20 passed to one ordinary TEXTJOIN formula combines the whole range into one result; it does not automatically make a separate result for every row.
Fill a combined result down many rows
For a short or moderate list, enter the formula in the first result cell and copy it down. Select the formula cell and drag its small fill handle down the column, or copy the cell and paste it into the destination rows. Google Sheets adjusts ordinary relative references as the formula moves. If you need to preserve a reference to a fixed cell while filling down, use dollar signs, as in $A$1, to make that reference absolute.
For a longer list that should update automatically as rows are added, Google Sheets supports ARRAYFORMULA. With first names in A2:A and last names in B2:B, enter =ARRAYFORMULA(IF(A2:A="","",A2:A&" "&B2:B)) in C2. If A2 is Ada and B2 is Lovelace, C2 displays Ada Lovelace; the same calculation is applied down the column, and rows with a blank first-name cell remain blank. Leave the cells below C2 clear so the array result has room to expand.
This pattern checks column A for a blank before joining. If your data can have a missing first name but a present last name, change the blank test to reflect your requirements—for example, check whether both source cells are blank. An array formula also occupies the output range, so you generally cannot edit one of its individual results directly. Correct the source data or change the formula instead.
Match rows from another table with a lookup
If “join columns” means bringing related information into a table, concatenate formulas are not enough. Suppose a sales sheet has product codes in A2:A, while a sheet named Products has product codes in column A and product names in column B. To return the product name for the code in A2, enter =IFNA(VLOOKUP(A2,Products!A:B,2,FALSE),"Not found") in the desired result cell. If A2 contains a code found in Products column A, the formula returns the corresponding name from column B; if it finds no match, it displays Not found.
The FALSE argument requests an exact match, which is generally important for identifiers such as codes and IDs. VLOOKUP searches the first column of its lookup range and returns a value from a column to its right, so the example uses Products!A:B. If a sheet name contains spaces, enclose it in single quotes in the reference, as in 'Product List'!A:B.
This is a formula-based lookup, not a database operation that physically combines two tables. It returns a value for each formula row and responds to changes in the source data. If a key appears more than once in the lookup column, VLOOKUP returns the first matching row, so duplicate keys may produce an unexpected result. Check that the key columns use consistent formats and that each identifier is unique when uniqueness is expected.
Choose a delimiter and handle dates or numbers
Joining cells converts their contents into text for display as one result. That is convenient, but numeric and date values can require extra care. A date may be stored as a serial number, and a number may lose leading zeros when it is treated as a number. If the exact display format matters, convert the value to text with an explicit format before joining.
With a name in A2 and a date in B2, where B2 is a date displayed as November 3, 2026, enter =A2&" — "&TEXT(B2,"yyyy-mm-dd"). The result is Ada — 2026-11-03. The TEXT pattern controls the date representation in the joined output; it does not change the underlying date in B2. Similarly, if an ID must retain leading zeros, store it as text in the source column or format it deliberately before concatenation.
Think about punctuation and missing values before choosing a delimiter. A comma-separated address may be readable, but if a city is optional you may want TEXTJOIN with its ignore-empty setting rather than a chain of ampersands that leaves extra commas. Also consider whether the result will be used for display or later calculations: once numbers are combined with text, the resulting cell is text, not a numeric total or a date value.
Common problems and ways to fix them
- The formula appears as text: Check that the cell is not formatted as plain text, remove any leading apostrophe, and re-enter the formula. A formula must begin with an equals sign.
- There is no space between words: Add a quoted space between references, as in
=A2&" "&B2. A space inside a cell is not automatically inserted. - The output has unwanted separators: Use
TEXTJOINwith TRUE as its ignore-empty argument when blank cells should be skipped. Check for cells that look empty but contain spaces. - An array result will not expand: Clear values or formulas from cells in its output area. An existing entry in the way prevents the formula from filling those cells.
- A lookup says Not found unexpectedly: Compare the key values for extra spaces, different number-versus-text formats, and spelling differences. Exact lookups need the underlying values to match.
- A formula reports a parse error: Check the parentheses, quotation marks, and separators. Depending on spreadsheet locale settings, Google Sheets may require semicolons instead of commas between formula arguments.
Google Sheets compared with Excel
The basic ampersand method and TEXTJOIN are also available in modern Microsoft Excel, so a simple formula such as =A2&" "&B2 is familiar in both programs. The main difference in the examples above is ARRAYFORMULA, which is a Google Sheets function and should not be assumed to work as written in Excel. Excel has its own ways to calculate results across arrays, and the details depend on the Excel version.
Google Sheets formulas recalculate as their referenced cells change, and Sheets can share a workbook for simultaneous online editing. If you download a spreadsheet for Excel, check formulas that use Sheets-specific functions or behavior; compatibility can vary. When collaborators use different spreadsheet programs or locale settings, agree on the expected separators and test a copy of the file before relying on a complex formula.
Frequently Asked Questions
How do I join two columns in Google Sheets with a space?
With the two values in A2 and B2, enter =A2&" "&B2 in the result cell. Fill the formula down to combine the corresponding cells in later rows.
How do I combine three or more columns?
Use TEXTJOIN with the range for one row. For example, with values in A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) joins them with spaces and ignores empty cells.
Can Google Sheets combine columns automatically for new rows?
Yes. An ARRAYFORMULA can apply a row-wise concatenation down a column. Keep the output cells below it clear so the calculated results can expand, and make sure the blank-cell test matches your data.
How do I join two sheets using a matching ID?
Use a lookup such as VLOOKUP with the ID as the search key and FALSE for an exact match. The lookup column must be the first column of the selected VLOOKUP range.
Does joining columns merge the cells?
No. Joining combines cell contents into a formula result. The Format > Merge cells command changes the cell layout and does not combine every selected value into text.
Related
- Unmerge Cells in Excel: Find the Command and Use It
- Where to Find Define Name in Excel and Manage Names
- Where Is the Superscript Button in Excel?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Automatically Splitting Text to Columns? Here’s WhyExcel does not normally split text into separate columns just because you type or paste a comma-separated phrase…
- Google Sheets IMPORTRANGE With Criteria: How to Filter DataGoogle Sheets’ IMPORTRANGE function does not have a built-in criteria argument; combine it with QUERY to import only…
- Can You Add an Image to a Header in Word?Yes. In Word for Microsoft 365 on Windows, open the header by choosing Insert > Header > Edit…
- Dynamic Forecast in Excel: Build One That UpdatesTo build a dynamic forecast in Excel, put monthly actuals in an Excel Table, add editable growth and…
- Excel Data Table Cycling Through Results? Fixes ExplainedIf an Excel What-If Analysis data table keeps cycling through different answers, it is usually recalculating a formula…
- Google Sheets Data Validation With Named Ranges ExplainedYes—Google Sheets can use a named range as the source for a data-validation dropdown. Name the cells that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.