To combine the text from two Excel cells into one, enter a formula such as =A2&" "&B2 in an empty cell; it joins the contents with a space and leaves the original cells unchanged. Do not use Excel’s Merge Cells command to combine text: that command joins the cell areas but keeps only the value in the upper-left cell.
The quickest formula for combining two cells
The ampersand (&) is Excel’s text-concatenation operator. In the formula above, the first cell’s value comes before the ampersand, a space is placed between two quotation marks, and the second cell’s value comes last. If A2 contains “Ada” and B2 contains “Lovelace,” the result is “Ada Lovelace.” Enter the formula in C2, for example, then press Enter.
The formula assumes A2 contains the first piece of text and B2 contains the second. The result appears in the formula cell, not in either source cell. This is useful because you can check the combined result before deciding whether to keep it as a formula or replace it with a fixed value.
To apply the formula to more rows, select the formula cell and drag its fill handle—the small square at the lower-right corner—down the column. Excel adjusts the references for each row, so the formula in C3 refers to A3 and B3. You can also double-click the fill handle when the adjacent column has data to indicate how far to fill.
Step-by-step: join text in Excel for Microsoft 365
- Put the first value in one column and the second value in another, with matching items on the same row. For example, use first names in A2:A20 and last names in B2:B20.
- Click an empty cell in the row where you want the combined result, such as C2.
- Type
=A2&" "&B2and press Enter. The quotation marks contain the separator, which is one space in this example. - Check the output for missing spaces, unexpected blanks, or values that need a specific format.
- Fill the formula down for the remaining rows. If you later edit A2 or B2, the result in C2 updates automatically.
This method works in Excel for Microsoft 365 on Windows and uses the same basic formula on Mac and in Excel for the web. The ribbon layout and some editing controls can vary by platform, but the ampersand formula does not. Keep the source columns until you have checked the results; the formula itself does not erase or move their contents.
Choose a formula that fits the job
For just two cells, the ampersand is direct and easy to inspect. Excel also has functions for joining text. In Microsoft 365, CONCAT combines text arguments without adding a separator, while TEXTJOIN can insert a chosen separator and optionally ignore empty cells. These are useful when a formula has several parts or a list of cells.
With first names in A2 and last names in B2, this alternative produces “Ada Lovelace”: =CONCAT(A2," ",B2). CONCAT does not insert spaces automatically, so the space in quotation marks is important. For a longer list, TEXTJOIN can be more compact.
With city names in A2:A5 containing “Boston,” a blank, “Chicago,” and “Denver,” respectively, this formula returns “Boston, Chicago, Denver”: =TEXTJOIN(", ",TRUE,A2:A5). The first argument sets the separator, TRUE tells Excel to skip empty cells, and the final argument is the range to combine. TEXTJOIN and CONCAT are available in current Microsoft 365 Excel; if you share a workbook with people using older Excel versions, check their compatibility before relying on newer functions.
Spaces, punctuation, and blank cells
Excel combines exactly the pieces you specify; it does not guess whether you want a space, comma, slash, or other separator. For names, use a space. For a label and an ID, a hyphen may be clearer. For a list, a comma followed by a space is common. The separator is ordinary text inside quotation marks, so you can change it to match the intended output.
With a product name in A2 and its size in B2, this formula uses a hyphen separator and returns “Mug – Large” when those are the source values: =A2&" - "&B2. The spaces around the hyphen are part of the quoted text; omit them if the desired result is “Mug-Large.”
A blank source cell can leave an awkward separator behind. For example, if A2 contains “Ada” and B2 is empty, the basic name formula still returns “Ada ” with a trailing space. If one or both inputs may be blank, use a formula designed to ignore empty cells. With A2:A3 containing “Ada” and a blank, respectively, =TEXTJOIN(" ",TRUE,A2:A3) returns “Ada” without an extra space. If you need a more complex rule—such as showing a comma only when both fields exist—test the formula against blank, partial, and complete rows before filling it down.
Combining dates and numbers without strange results
When you concatenate a date or number, Excel may show its underlying stored value or a format different from the one displayed in the source cell. A date is stored as a serial number, so joining it directly with text may produce an unexpected number instead of a readable date. Apply the desired display format inside the formula with TEXT.
Assume A2 contains “Review” and B2 contains the date October 14, 2026. The formula =A2&" - "&TEXT(B2,"mmm d, yyyy") returns “Review – Oct 14, 2026.” The format pattern controls the date’s appearance: for example, “mmmm d, yyyy” spells out the month as “October 14, 2026.”
The same idea works for numeric values. If A2 contains “Total” and B2 contains the number 1250.5, =A2&": $"&TEXT(B2,"#,##0.00") returns “Total: $1,250.50.” This changes how the number is displayed in the combined text; the result is text, not a number suitable for arithmetic. Keep the original numeric cell if you still need to calculate with it.
Why Merge Cells is not the same thing
Excel’s Merge Cells feature changes the layout of a range, commonly to make a heading span several columns. It does not concatenate the values from those cells. If you select A2 and B2 and choose Home > Merge & Center > Merge Cells, Excel keeps the value in the upper-left cell and discards the other cell’s content. If both cells contain data, Excel warns that only the upper-left value will be retained.
That makes Merge Cells unsuitable for joining first and last names, addresses, or other records. It can also make sorting, filtering, copying, and selecting ranges more awkward because a merged area behaves differently from a normal grid of cells. For a heading that should span columns, merging may be appropriate; for combining information, use a formula or another text-joining method instead.
If the goal is only to center a heading across columns without creating a merged cell, Excel also offers Center Across Selection in the Format Cells alignment options. That changes the appearance without combining the underlying cells. It is a layout alternative, not a way to join their text.
Make the combined text permanent
A formula result changes when its source cells change. If you need a fixed text value—for example, before sending a workbook to someone who should not see formulas—copy the result cells and paste their displayed values over or into another range.
On Windows, select and copy the formula results, then use Home > Paste > Paste Values. In current Excel for Mac, use the Paste Values option from the Paste menu or the paste options that appear after copying; labels and placement can differ slightly by build. Paste into a separate column first if you want to preserve the formulas. Confirm that the pasted values look right before deleting the original columns. Once pasted as values, the combined text no longer updates when the source cells change.
Be careful when pasting values over the source cells themselves. If the formula refers to those cells, replacing them can remove the data needed to calculate the result. A safer sequence is to create the combined column, copy it, paste values into a new location, verify it, and only then decide which columns to remove.
Alternatives for repeated or larger jobs
Flash Fill can recognize a pattern from examples. For instance, type “Ada Lovelace” beside the first row of names, then start entering the next combined name. On Excel for Windows, choose Data > Flash Fill, or press Ctrl+E, and review the filled results. Flash Fill creates text values rather than formulas, so later changes to the source names do not automatically update the output. It is convenient for one-time transformations, but inspect the results because Excel may infer a pattern incorrectly when the data is inconsistent.
For repeatable cleanup of a larger dataset, Power Query can merge columns while importing or transforming data. In Excel for Windows, convert the range to a table if needed, then choose Data > From Table/Range. In Power Query Editor, select the columns to combine and choose Transform > Merge Columns. Pick a separator, name the new column, and confirm; then use Home > Close & Load to return the results to Excel. The exact choices depend on the data, and a query can be refreshed when its source data changes. Unlike a worksheet formula, the query output updates when you refresh the query, not necessarily immediately after each cell edit.
Common problems and quick checks
- The formula appears as text: The cell may be formatted as Text, or the formula may begin with an apostrophe. Change the cell format to General, then re-enter the formula.
- There is no space between words: Add a quoted separator, such as
" ", between the cell references. - The result shows a date serial or an unexpected number: Wrap the numeric or date value in TEXT and specify a display pattern.
- One cell’s contents disappear: You likely used Merge Cells rather than a concatenation formula. Undo immediately if possible, or restore the value from a backup or source.
- The results do not change: Check that calculation is set to Automatic under Formulas > Calculation Options, and confirm that the formula references the cells you are editing.
Also distinguish a real blank cell from one containing a formula that returns an empty string. Some joining approaches treat these differently. A few sample rows—with both values present, one missing, and both missing—are a quick way to catch edge cases before applying a formula to thousands of records.
Frequently Asked Questions
Can I combine two cells without a space?
Yes. With the values in A2 and B2, use =A2&B2. If they contain “North” and “side,” the result is “Northside.” Add punctuation or a space inside quotation marks if you want a separator.
Does combining cells delete the original text?
No, not when you use a formula in a separate cell. The source values remain in their original cells. The Merge Cells command is different: it retains only the upper-left cell’s value and can discard other selected values.
Can I combine more than two cells?
Yes. Join additional references with ampersands, or use TEXTJOIN for a range. With values in A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) joins nonblank values with spaces between them.
How do I combine cells and keep the result when the source changes?
Copy the formula results and paste values into a new range. The pasted text remains fixed; it will not recalculate if the original cells are edited.
Can I combine cells across rows with a line break?
Yes. With text in A2 and B2, use =A2&CHAR(10)&B2, then turn on Home > Wrap Text for the result cell. CHAR(10) inserts a line break; row height may need adjustment so both lines are visible.
Related
- Excel Import CSV from Clipboard? Methods That Work
- Excel Import CSV: Open Comma-Separated Files Correctly
- Excel Import CSV as Text: Keep Every Value Unchanged
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Keep the Home Tab Open in Excel: Show the RibbonTo keep Excel’s Home tab visible, expand the ribbon, choose the option to always show it, and click…
- Blocking a Sender in Outlook: Steps and What to KnowTo block a sender in Outlook, select one of their messages and choose Block or Block Sender from…
- Excel Table Creation: How to Set Up and Use TablesTo create an Excel table in Microsoft 365 for Windows, select a cell in a contiguous data range,…
- Excel Not Keeping Formatting? Causes and FixesIf Excel is not keeping formatting, first check whether the change comes from conditional formatting, a table style,…
- Google Sheets Freeze Bottom Row: What Works InsteadNo. Google Sheets can freeze rows at the top of a sheet, but it has no built-in command…
- How to Delete a Page in Word for the Web (Browser)To delete a page in Word for the web, select the text or other content on that page…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.