To combine two text columns in Excel, enter a formula in a new column and fill it down. With the first text in A2 and the second in B2, use =A2&" "&B2; for example, A2 containing Maya and B2 containing Chen produces Maya Chen. The formula joins the cell contents with one space, leaving the original columns unchanged.
This guide uses Microsoft Excel for Microsoft 365 on Windows. You can combine names, addresses, labels, or other text in the same way. Decide first whether the result should include a separator, such as a space or comma, and whether you need a live formula or fixed text.
What You’ll Need
- An Excel worksheet with the two text columns you want to join. The examples use columns A and B, with headers in row 1 and the first records in row 2.
- An empty column for the combined results. Keeping the source columns intact makes it easier to check your work and revise the output.
- Excel for Microsoft 365, Excel 2021, or another recent desktop version. The ampersand formula used below works in older Excel versions too; the optional TEXTJOIN method requires Excel 2019 or later, including Microsoft 365.
Step-by-Step
-
Check the source columns. Confirm that each row contains the two pieces of text that belong together. For example, A1 might be First name and B1 Last name, with Maya in A2 and Chen in B2. If your data has headers, do not include the header row in the formula unless you want to combine the header labels as well. Also check that the two columns are aligned row by row; joining A2 with B2 will combine those cells, not search for a matching name elsewhere.
-
Make room for the result. Choose a blank column beside the source data, such as C, and label C1 Combined name. A clear heading helps distinguish the output from your original text. If column C already contains information, choose another empty column or insert a new one before proceeding, so you do not overwrite anything important.
-
Enter a formula in the first result row. With the first text in A2 and the second text in B2, click C2 and type
=A2&" "&B2, then press Enter. The formula uses the ampersand operator to join the two cell values, and the text in quotation marks supplies a single space between them. If A2 is Maya and B2 is Chen, C2 displays Maya Chen. The formula refers to the source cells, so it will update if either value changes. -
Choose a separator that suits the text. If you need no separator, with the same values in A2 and B2 enter
=A2&B2in C2; Maya and Chen then produce MayaChen. For a comma and space, with those same source cells use=A2&", "&B2; the result is Maya, Chen. The separator is ordinary text inside quotation marks, so you can replace it with a hyphen, slash, or other character. Use exactly the punctuation you want to see in each result. -
Fill the formula through the rest of the rows. Select C2. Point to the small square at the lower-right corner of the selected cell, called the fill handle, and drag it down to the last row of your data. Excel adjusts the row references automatically: the next row will refer to A3 and B3, then A4 and B4, and so on. If the neighboring source column has continuous data, you can often double-click the fill handle to fill down to the end of that adjacent data. Check the last filled row to make sure it reaches every record.
-
Review the output before relying on it. Look at several rows, including the first and last, and check spacing, punctuation, and blank cells. If the combined text appears cut off, widen column C by dragging the boundary between its column letters, or double-click that boundary to AutoFit the width. A narrow column can hide part of a result on screen without changing the actual cell value.
-
Decide whether to keep formulas or save fixed text. Keep the formulas if the output should change whenever the source columns change. If you need a stand-alone result, select the completed output cells and copy them. Then use Home > Paste > Values to paste the displayed text over the copied formulas, or into another empty column. Check the pasted results before deleting or changing the source columns. Pasting values prevents the combined text from changing when the original cells are edited.
Alternative for optional spaces: When some source cells may be blank, TEXTJOIN can skip empty cells instead of leaving an extra separator. With the first and second text in A2 and B2, enter =TEXTJOIN(" ",TRUE,A2,B2) in C2. If A2 contains Maya and B2 is blank, the result is Maya rather than Maya followed by a space. If both cells contain text, it returns Maya Chen. You can fill this formula down just like the ampersand formula. TEXTJOIN is available in Excel 2019 and later, including Microsoft 365; use the ampersand method for broader compatibility.
Common Mistakes
- Leaving out the separator:
=A2&B2joins the text exactly as stored. That is right for some codes, but first and last names can run together. Include a space or suitable punctuation when the result needs it. - Using a separator that is not in quotation marks: In a formula, a literal space or comma must be enclosed in straight double quotation marks. The formula
=A2&" "&B2includes a space; a formula without those quotation marks may be interpreted differently or return an error. - Overwriting the source data too soon: A formula in the result column depends on the source cells. If you remove or move those cells before converting the results to values, the output may change or show an error. Keep a backup or paste values first.
- Assuming the formula changes the original columns: It creates a result in another cell; it does not merge or erase the original entries. This is usually safer, because you can correct the result or rebuild it later.
- Filling only part of the list: A drag that stops early leaves later rows without combined text. Compare the last output row with the last source-data row and fill any missing formulas.
- Confusing hidden text with missing text: A narrow column may display only part of a long combined result. Widen the column or select the cell and inspect the formula bar before concluding that characters were lost.
Tips
- Use a separator consistently. Names usually read naturally with a space; address parts may need a comma and space. For phone fragments, product codes, or IDs, you may need no separator. Preview a few rows before filling the full column.
- Use TEXTJOIN when blanks are common. With A2 and B2 as the two source cells,
=TEXTJOIN(" ",TRUE,A2,B2)ignores empty cells while joining. The TRUE argument tells Excel to ignore empty items. This is convenient for optional middle names or address fields, though it does not remove spaces that are already typed inside a source cell. - Keep a formula column until you have checked the results. Formulas make corrections easy: edit a source cell and the output recalculates. If you need a fixed export for another system, convert the results to values only after you have reviewed them.
- Use Excel’s fill tools for longer lists. Dragging the fill handle is straightforward for a short range. For a selected range that already includes the formula in its top cell, Ctrl+D on Windows fills the formula down. On Excel for Mac, Control+D is the Fill Down shortcut in many current versions; keyboard mappings can vary with system settings. You can also copy the formula cell and paste it into the cells below.
- Format the result column for readability. Widen it, wrap text, or use a suitable number format only if the content requires it. Text joining does not need a special cell format. For long addresses, Home > Wrap Text can show multiple lines within each cell, although the combined text itself stays in one cell.
Troubleshooting
The formula displays instead of a combined result. The cell may be formatted as Text, or the entry may start with an apostrophe. Change the cell format to General using Home > Number Format > General, then re-enter the formula by selecting the cell, pressing F2, and pressing Enter. Changing the format alone may not make an existing formula recalculate as a formula; re-entering it usually does.
Excel shows an error after you enter the formula. Check that the formula begins with an equals sign, each cell reference is spelled correctly, and the quotation marks around the separator are balanced. If you copied a formula from a web page or document, replace curly quotation marks with straight quotation marks. Some regional settings use semicolons rather than commas as function argument separators. The basic ampersand formula has no function arguments, so it avoids that particular separator issue.
There are unexpected spaces in the output. The formula adds only the separator you specified; it does not clean spaces already present in A2 or B2. Inspect the source cells for leading or trailing spaces, which are easy to miss. If the cells include unwanted spaces, clean the source text first or use a carefully checked cleanup formula. Avoid automatically trimming data when spaces may be meaningful, such as in a code or formatted label.
Blank source cells leave an awkward gap. The standard ampersand formula always inserts its chosen separator, even if one of the two referenced cells is blank. If you want Excel to skip blank values, use the TEXTJOIN option above, with A2 and B2 as the inputs: =TEXTJOIN(" ",TRUE,A2,B2). If your version does not support TEXTJOIN, you can handle blanks with a conditional formula, but check the desired result for both possible blank positions before filling down.
The results stop updating, or change unexpectedly. If the cells are formulas, confirm that Excel calculation is set to Automatic: Formulas > Calculation Options > Automatic. If you pasted values, the combined text is fixed and will not update when the source changes; repeat the combine operation if you need a refreshed result. Also check that the formula points to the intended rows rather than to a different range.
The output seems incomplete after moving columns. A formula can show an error or point somewhere unexpected if its source cells were deleted or replaced. Undo immediately if the change was just made and is still undoable. Otherwise, restore the source data from a backup or edit the formula references, then verify several rows before using the results.
Frequently Asked Questions
How do I combine two columns in Excel without a space?
With the two values in A2 and B2, enter =A2&B2 in the result cell and fill the formula down. Excel joins the contents directly, so Maya and Chen become MayaChen.
Can I combine two columns with a comma between them?
Yes. With the values in A2 and B2, enter =A2&", "&B2. It inserts a comma followed by a space between the two values. Change the text between the quotation marks if you need a different separator.
Can I combine two columns and remove the originals?
Yes, but preserve the combined output first. Copy the result cells and use Home > Paste > Values, then confirm that the pasted text is correct. Only then should you remove source columns, and it is wise to save a copy of the workbook before deleting them.
Will the combined result update when I edit either source cell?
It will update if the result is still a formula, such as =A2&" "&B2. It will not update after you paste the result as a value; values are fixed text until you create them again.
Can I combine more than two columns?
Yes. With text in A2, B2, and C2, use =A2&" "&B2&" "&C2 to put a space between each value. If some cells might be blank, TEXTJOIN can be easier to maintain: with those same cells, use =TEXTJOIN(" ",TRUE,A2,B2,C2).
Does this work in Excel for Mac or Excel for the web?
The ampersand formula and TEXTJOIN are available in current Excel for Mac and Excel for the web as well as Excel for Windows. Ribbon labels and keyboard shortcuts may differ slightly by platform, but entering the formula in a blank column and filling it down works the same way.
Related
- Flash Fill Multiple Cells in Excel: Steps and Limits
- Excel Flash Fill in Polish: Name and How to Use the Feature
- Flash Fill Excel Practice: Examples and Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel What-If Analysis: Tools and ExamplesExcel What-If Analysis lets you change assumptions in a worksheet and see how those changes affect a result.…
- Excel Biweekly Timesheets: Setup and Formula GuideYes. Excel can track biweekly timesheets by recording each shift in a 14-day date range, calculating hours, and…
- SUMIF Excel Shortcut: The Fastest Way to Use ItExcel has no dedicated keyboard shortcut that inserts a SUMIF formula automatically. The quickest method is to type…
- Easy Way to Sum in Excel: Formulas and ShortcutsThe easiest way to sum numbers in Excel is to select the blank cell beneath or beside them…
- Excel Row Number Formula Examples and UsesIn Excel, enter =ROW() to return the row number of the cell containing the formula; for example, in…
- Excel Custom Text Filter: Find Matching Text in a ListTo use a custom text filter in Excel, open the filter arrow in a text column, choose Text…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.