To join two text columns in Excel, enter a formula such as =A2&" "&B2 in a third column, assuming A2 contains Maya and B2 contains Chen; the result is Maya Chen. The ampersand joins the cell contents, and the quoted space inserts a separator between them.
Quick answer: join two columns with an ampersand
In Microsoft Excel for Microsoft 365 on Windows, the ampersand (&) is a direct, widely compatible way to combine text. Put the formula in the first row of an empty result column, then copy it down for the other rows. In the example above, enter the formula in C2. Excel calculates the combined text while leaving the original values in columns A and B unchanged.
The separator is part of the formula, not something Excel adds automatically. For a space, include " "; for no separator, join the cell references directly. If A2 contains Maya and B2 contains Chen, the formula =A2&B2 returns MayaChen. The formula =A2&", "&B2 returns Maya, Chen. This also works with labels, product details, addresses, and other text—not just names.
Three ways to combine text in Excel
Excel offers several ways to join values. For the common case of two cells, the ampersand is usually easiest to read and type. The functions CONCAT and TEXTJOIN are useful when you want a function-based formula or need to combine several cells.
- Ampersand (&): Joins cell references and text pieces in the order you specify. It is a practical choice for two columns and works in older Excel versions as well as Microsoft 365.
- CONCAT: Joins text or cell references without adding a separator for you. With Maya in A2 and Chen in B2, enter
=CONCAT(A2," ",B2)in C2 to return Maya Chen. Add the space as a separate argument. - TEXTJOIN: Joins text using a delimiter you choose and can skip empty cells. With Maya in A2, B2 blank, and Chen in C2, enter
=TEXTJOIN(" ",TRUE,A2:C2)in D2 to return Maya Chen. The TRUE argument tells Excel to ignore empty cells.
CONCAT and TEXTJOIN are available in Microsoft 365; they also appear in supported newer perpetual versions of Excel. If a workbook must work in an older release that does not recognize one of these functions, the ampersand is a safer option. Excel may display an unrecognized function as an error when opened in an older version.
Choose the separator you need
Joining does not mean the same thing as inserting a space. Excel combines exactly what the formula specifies, so decide whether the result should contain a space, punctuation, or nothing between the values. The delimiter should match the way the combined field will be read or used later.
- Full names: Use one space between first and last name, such as Maya Chen.
- Readable labels: Use a comma and space, such as North, East.
- Codes: Use a hyphen or underscore if the target system expects it, such as AB-204.
- Continuous identifiers: Use no delimiter when the combined value is meant to be one uninterrupted string.
Text typed directly into a formula must be enclosed in straight double quotation marks. A space between quotation marks is a real space; quotation marks with nothing between them represent an empty string. If you use a comma or dash as a separator, put it inside those quotation marks. A comma used to separate formula arguments is different from a comma included inside quoted text.
Handle blank cells and optional values
A blank cell can affect the appearance of a joined result. With an ampersand formula that always adds a space, a blank second cell can leave a trailing space; a blank first cell can leave a leading one. These spaces may be hard to see, but they can matter when searching, sorting, comparing text, or exporting data.
For two or more cells, TEXTJOIN can skip blanks while applying a consistent delimiter. With A2:C2 containing Maya, a blank cell, and Chen, the formula =TEXTJOIN(" ",TRUE,A2:C2) returns Maya Chen. Change TRUE to FALSE if you want empty cells included in the sequence; separators can then appear in positions corresponding to blanks. This is useful when the input columns are optional, such as middle names or address line 2.
If you prefer the ampersand for just two cells, TRIM can remove leading and trailing spaces and reduce repeated spaces between words. With A2 containing Maya and B2 blank or Chen, enter =TRIM(A2&" "&B2) in C2. It returns Maya when B2 is blank and Maya Chen when B2 contains Chen. TRIM also changes repeated spaces within the combined text to single spaces, so do not use it when multiple consecutive spaces are intentional.
Join dates, numbers, and formatted values
Excel stores dates as numeric values and often stores numbers separately from the way they appear on screen. When a formula joins a date or number with text, the result may not preserve the source cell’s displayed formatting. A date that appears as March 5, 2026 in its cell, for example, may turn into a serial number in a joined result.
Use the TEXT function when the joined value needs a specific display format. With A2 containing the date March 5, 2026 and B2 containing Report, enter =TEXT(A2,"mmmm d, yyyy")&" - "&B2 in C2; the result is March 5, 2026 – Report. The format code specifies a full month name, day, and four-digit year. For a number, format codes can specify decimal places, percentages, or other display details.
Remember that this creates text, not a date or number that Excel can calculate with as the original value. If you need to sort or calculate using the date or number later, keep the source value in its own column and use the joined result only as a display label.
Fill the formula down the column
After entering a formula in the first result row, copy it to the remaining rows. If the source data runs from row 2 to row 100, put the formula in C2 and use the fill handle—the small square at the bottom-right corner of the selected cell—to drag down to C100. You can also double-click the fill handle when the adjacent source column has continuous data; Excel generally fills down to the end of that neighboring data.
Cell references such as A2 and B2 are relative references. When the formula is copied one row down, Excel adjusts them to A3 and B3, so each output uses its own row’s values. For example, if row 3 contains Leo in A3 and Park in B3, the copied formula returns Leo Park. Check a few rows after filling, especially when the source data has gaps.
If you need to replace formulas with fixed text, copy the results and choose Home > Paste > Values. This keeps the displayed combined text but removes the formulas’ links to the source cells. Before doing so, make sure you no longer need the result to update when the original columns change. On Mac, the ribbon command is also available; standard copying shortcuts are Ctrl+C on Windows and Command+C on Mac.
Common problems and how to fix them
- The words run together: Add a quoted separator between the references. Excel will not insert a space automatically.
- The result displays the formula instead of the answer: Check whether the cell is formatted as Text. Change it to General, then re-enter the formula. Also confirm that the formula starts with an equals sign and that Show Formulas is not turned on.
- A date becomes a number: Wrap the date reference in TEXT and supply the format you want, as shown above.
- There is extra spacing: Check for spaces already present at the beginning or end of the source cells. TRIM can clean ordinary excess spaces, but it also reduces repeated internal spaces.
- You see #NAME?: Excel may not recognize a function name, often because the workbook is opened in a version that does not support it or the function was misspelled. Use the ampersand method for broad compatibility.
A formula result may also look correct while containing invisible spaces. If two text values that appear identical do not match in a lookup or comparison, inspect the source cells for leading, trailing, or nonbreaking spaces. TRIM handles ordinary spaces, but it does not remove every type of whitespace character. Clean imported data before relying on exact matches.
Formula result or permanent text?
A joined formula updates automatically when its source cells change. That is useful for live reports, contact lists, and labels that need to stay synchronized. It also means the combined result depends on the source columns remaining available and correctly populated.
Paste Values is an alternative when you need a fixed text result—for example, before sending a copy to a system that should not receive formulas. Keep a copy of the original workbook or source data if you may need to revise the results later. Another option is to leave the original columns intact and use the joined column only for display or export, rather than replacing data that may be useful separately.
Frequently Asked Questions
How do I join two columns in Excel without a space? Join the cell references directly with an ampersand. With values in A2 and B2, use =A2&B2 in C2. Excel returns the two values next to each other.
Can I combine two columns and add a comma? Yes. With the values in A2 and B2, enter =A2&", "&B2 in C2 to place a comma and space between them. Change the quoted delimiter if you need different punctuation.
How do I join cells while ignoring blanks? Use TEXTJOIN with TRUE as its ignore-empty argument. If the cells are A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) joins nonblank entries with spaces. This avoids adding a separator for an empty cell.
Will the joined text update when I edit a source cell? Yes, if the result is still a formula. Excel recalculates the joined value when a referenced cell changes. If you paste the result as a value, it becomes fixed text and will no longer update.
Can I join more than two columns? Yes. Use additional ampersands between references, or use CONCAT or TEXTJOIN for a longer range. TEXTJOIN is especially convenient when you want one delimiter and need empty cells skipped.
Related
- Excel Shortcut to Hide a Column on Windows and Mac
- Excel: Hide Row and Column Numbers from the Worksheet View
- Excel Hide Specific Columns: Steps and Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Days Until Date: Formulas, Examples, and FixesTo calculate calendar days until a date in Excel, subtract today’s date from the target date: with the…
- Excel Find and Replace: Values, Formulas, and OptionsTo find and replace values in Excel, press Ctrl+H on Windows, enter the text or value under Find…
- COUNTIF Excel: How to Count Matches and Sum ValuesCOUNTIF in Excel counts cells that meet one condition; it does not add the values in those cells.…
- Excel Date Plus 1 Day: Formula, Examples, and FixesTo add one day to an Excel date, add 1 to the date cell. If the date is…
- Sort Excel Oldest to Newest: Dates, Data, and FixesTo sort dates in Excel from oldest to newest, select a cell in the date column, then choose…
- Excel Accounting Shortcuts: Formulas, Keys, and TipsExcel accounting shortcuts are a mix of keyboard commands and formulas: use Alt+= to insert an AutoSum, Ctrl+T…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.