To combine words from two Excel cells, enter a formula such as =A2&" "&B2 in an empty cell; it joins the contents with a space and updates when either source cell changes. Use TEXTJOIN when you need to combine several cells or skip blanks. These methods combine the text in a new cell; they do not merge the original cells or erase their contents.
What You’ll Need
- An Excel workbook with the words you want to combine, such as first names in column A and last names in column B.
- An empty column or cell for the combined result. Keeping the original columns makes it easier to check your work and change the formula later.
- Excel for Microsoft 365 on Windows for the steps below. The basic ampersand formula also works in Excel for Mac and Excel for the web. The ribbon layout can vary slightly by platform.
Step-by-Step
- Check the source cells and decide on a separator. Look at a few rows to confirm where each part of the text appears. For example, if given names are in column A and surnames in column B, decide whether the result should read as two words separated by a space. If you are joining a city and a region, you may prefer a comma and a space. Choose an unused column for the results, and add a heading such as Full Name so the new data is easy to identify.
- Enter a basic formula for two cells. With a given name in A2 and a surname in B2, click the empty result cell, such as C2, and type
=A2&" "&B2. Press Enter. If A2 contains Ada and B2 contains Lovelace, C2 displays Ada Lovelace. The ampersand joins text, and the quoted space puts a visible gap between the words. Without that space, the result would read AdaLovelace. The formula leaves A2 and B2 unchanged. - Copy the formula to the other rows. Select the cell containing your formula. Point to the small square at its lower-right corner, called the fill handle, and drag it down to the last row of data. Excel adjusts the row references for each result: the next row will refer to A3 and B3, for example. If the data is in a continuous block with no blank rows, you can also double-click the fill handle to fill down alongside the adjacent data. Check the bottom few results to make sure the formula reached the intended rows.
- Join three or more cells with separators. With a first name in A2, a middle name in B2, and a surname in C2, use
=A2&" "&B2&" "&C2to put a space between each entry. If A2 is Ada, B2 is Augusta, and C2 is Lovelace, the result is Ada Augusta Lovelace. To use punctuation instead, with a city in A2 and a region in B2, enter=A2&", "&B2; Paris and Île-de-France produce Paris, Île-de-France. Put the punctuation inside quotation marks so Excel treats it as text. Extend the same pattern by adding another ampersand and a separator before each extra cell. - Use TEXTJOIN when some cells might be blank. A formula that adds a space between every cell can leave extra spaces when a middle entry is empty. With possible name parts in A2:C2, enter
=TEXTJOIN(" ",TRUE,A2:C2). If A2 contains Ada, B2 is blank, and C2 contains Lovelace, the result is Ada Lovelace, with no extra space for the empty cell. The first argument is the separator, TRUE tells Excel to ignore empty cells, and A2:C2 is the range to join. In Microsoft 365, you can use this approach for a longer row of text cells by changing the range. - Fill down and inspect the output. Copy the TEXTJOIN formula down just as you would the basic formula. Review examples with every expected pattern: rows with all parts filled in, rows with a blank middle entry, and rows with only one entry. If a result looks wrong, click its cell and inspect the formula bar. Confirm that the formula refers to the correct source columns and that the separator matches your intended format.
- Keep the formulas or save fixed text. Formula results update when source cells change, which is useful for lists that are still being edited. To make a fixed copy, select the result cells and copy them. Then use Home > Paste > Paste Values to replace the formulas with their displayed text. Keep the original columns until you have checked the pasted results. If you no longer need the source columns, remove them only after confirming that the combined text is correct.
The formulas above work in Excel for Microsoft 365 on Windows. Excel for Mac and Excel for the web also support the ampersand operator and TEXTJOIN; names for ribbon controls may appear in slightly different places. On Mac, you can enter the formula and use the fill handle in the same way. In the web version, edit the cell in the browser and use the fill handle or the Home ribbon to copy the formula. If your regional settings use semicolons between function arguments, Excel may require semicolons in TEXTJOIN instead of commas; the ampersand examples do not use function arguments.
Common Mistakes
- Using Merge & Center to join words. The merge command combines a cell area into one larger cell; it does not combine the text from all those cells. When multiple selected cells contain values, Excel keeps only the upper-left cell’s content and can warn that other content will be discarded. Use a formula in a separate cell instead.
- Leaving out the separator. Joining A2 and B2 directly with an ampersand puts their contents together with nothing in between. Add a quoted space, comma, dash, or other separator where needed. Make sure punctuation is inside the quotation marks, not typed as part of a cell reference.
- Expecting a formula result to be permanent. A formula displays combined text but still depends on the source cells. If a source value changes, the result changes too. Use Paste Values only when you deliberately need a static copy, and retain a backup of the original data if it matters.
- Copying the formula into the wrong rows. A formula filled too far can create results beside blank records; one filled too short leaves some records unfinished. Compare the first and last intended rows with the source list before relying on the output.
- Overlooking spaces already in the source text. If a source cell already ends with a space and your formula adds another, the combined result may have an awkward gap. You can clean the source data or use TRIM in a formula when trimming is appropriate. Note that TRIM removes leading and trailing spaces and reduces repeated spaces between words.
Tips
- Choose a separator that suits the result. Names usually need a space, while labels may read better with a dash or comma. Preview a few combinations before filling down so you do not have to revise every row later.
- Use TEXTJOIN for optional parts. It is usually clearer than building a long chain of ampersands when several cells may be blank. Set its ignore-empty argument to TRUE when blank cells should contribute nothing. A cell containing a formula that returns an empty string is treated as empty for this purpose.
- Preserve intentional punctuation and spacing. If a cell contains a title such as Dr. or a suffix such as Jr., decide whether the surrounding separator belongs before or after that part. Check how the joined result reads aloud; that often reveals missing spaces or punctuation.
- Be careful when joining dates or numbers with words. Excel may use a date’s underlying number when you combine it directly with text. With a label in A2 and a real date in B2, enter
=A2&" "&TEXT(B2,"mmm d, yyyy")to display a readable date. If A2 is Due and B2 contains May 6, 2026, the result is Due May 6, 2026. Change the TEXT format code to a date style that suits your list. - Use Flash Fill for a one-time pattern. Type the desired combined result manually in the first result row, then select the next cell in that result column and choose Data > Flash Fill. In Windows, Ctrl+E is the Flash Fill shortcut. Flash Fill tries to infer the pattern and fills the remaining rows as static text rather than formulas, so review its suggestions carefully. On Mac, use the Data ribbon command if available in your Excel version.
Troubleshooting
The formula appears as text instead of a result. Check whether the cell is formatted as Text or whether an apostrophe appears before the equals sign. Change the cell format to General, edit the cell, and press Enter again. If Show Formulas is enabled, Excel displays formulas in cells instead of their results; toggle it from the Formulas tab or press Ctrl+` on Windows. On Mac, use the Show Formulas control on the Formulas tab if the shortcut differs on your keyboard layout.
The result has no space or has too many spaces. Inspect the separator between the cell references, then check whether the source values include extra spaces. A quoted space adds exactly one space, but it does not remove spaces already present in the source. If the text is messy, clean the source cells or apply TRIM to the individual text values before joining them; check a sample first because intentional repeated spacing will also be reduced.
TEXTJOIN gives an error. Confirm that the formula uses straight double quotation marks around the separator and that the parentheses are balanced. If Excel flags the commas between arguments, your regional settings may require semicolons. If Excel reports an unrecognized function, confirm that you are using a version that includes TEXTJOIN; the ampersand method is a straightforward alternative for a small number of cells.
Part of the data is missing or appears in the wrong order. Click the result and check the cell references in the formula bar. Verify that you selected the intended range and that the source columns have not shifted. If you sorted only one source column, the parts may no longer belong to the same record; undo the sort if possible, or sort the entire data range together before combining values.
The result looks right but changes unexpectedly. This is normal for a formula because it recalculates from its source cells. If the text must stay fixed, copy the results and choose Home > Paste > Paste Values. If you accidentally replace a formula or source value, use Undo immediately; after saving or making many later edits, restoring a prior version or backup may be necessary.
Frequently Asked Questions
Does combining cells delete the original words?
No. A formula displays the combined text in a separate result cell and leaves the source cells intact. Merging cells with the Merge & Center command is different: it can discard values from cells other than the upper-left one. Keep the original data until you have checked the result.
Can I combine words from cells with a comma between them?
Yes. Add a comma and a space as the separator in your formula. For a simple pair of cells, use the ampersand method with the quoted separator; for a range that may include blanks, TEXTJOIN lets you set the comma-space separator and skip empty cells.
How do I combine cells without leaving extra spaces for blanks?
Use TEXTJOIN with TRUE as its ignore-empty argument. It skips empty cells while inserting the separator between the remaining entries. If you use ampersands instead, you may need a more tailored formula or to clean the blank entries, especially when there are several optional parts.
Can I combine cells into one cell without a formula?
For a single one-time pattern, type an example and try Data > Flash Fill; inspect the filled values because Excel is inferring a pattern. For a consistent result that should update when the source changes, use a formula. Copy and Paste Values converts formula results into fixed text.
Will the combined text update when I edit a source cell?
Yes, if the result is still a formula. Excel recalculates it when a referenced source cell changes. If you have pasted the result as values, it is fixed text and will not update; you would need to combine the revised source data again.
Can I combine words from cells on different worksheets?
Yes. A formula can refer to another worksheet by including its name and an exclamation mark before the cell reference. For sheet names with spaces, Excel surrounds the sheet name with single quotation marks. The result still goes in a cell on the worksheet where you enter the formula.
Related
- How to Remove Duplicates in Excel Safely, Step by Step
- Remove Duplicates in Excel by Entire Row: A Safe Guide
- Remove Duplicates in Excel: A Clear Step-by-Step Guide
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Compare Rows in Two Excel Sheets: Formulas and MethodsTo compare rows in two Excel sheets, compare corresponding cells when the rows are in the same order,…
- Excel IF Formula Examples: Tests, Logic, and ErrorsExcel’s IF formula checks whether a condition is true or false and returns one result for each outcome.…
- Excel INDEX MATCH With Table Structured ReferencesYes—Excel INDEX MATCH works with table structured references. For example, if a table named Inventory has columns Item…
- Excel SUM OFFSET: Create Flexible, Expanding TotalsIn Excel, combine SUM and OFFSET to total a range whose size or position can change: for example,…
- Today’s Date in Excel: Shortcut and TODAY() FormulaIn Excel for Microsoft 365 on Windows, press Ctrl+; (Control plus semicolon) to insert today’s date as a…
- Xlookup vs vlookup?XLOOKUP defaults to exact matches and can return values from either side. See where VLOOKUP still fits and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.