To combine the text from two Excel cells without losing either value, enter a formula such as =A2&" "&B2 in a third cell; with “Maya” in A2 and “Chen” in B2, it returns “Maya Chen.” Excel’s Merge Cells command is different: it joins the cell areas, but keeps only the upper-left cell’s contents and discards the other selected value.
Combining text is not the same as merging cells
People use “merge” to mean two different things in Excel. They may want to join the words or numbers stored in separate cells into one text value, or they may want to make two adjacent cells look like one larger cell. A formula does the first job; the Merge Cells command does the second. Choosing the wrong method can lose data or create a sheet that is harder to work with.
For example, suppose A2 contains a first name and B2 contains a last name. A formula can produce the full name in C2 while leaving both source cells untouched. If you instead select A2:B2 and choose Merge Cells, Excel keeps the value from A2 and removes the value from B2. The resulting wider cell does not contain both names.
When the goal is a combined label, use a formula. When the goal is a heading that spans several columns, use cell merging only if the cells do not contain separate information. For a heading, another option is Center Across Selection, which centers text across a selected range without physically merging the cells.
Join two cells with the ampersand formula
The ampersand (&) joins text values and is a straightforward option for two cells. With the first text in A2 and the second in B2, enter =A2&B2 in C2. If A2 contains “North” and B2 contains “wind,” the result is “Northwind.” Add a separator inside quotation marks when the pieces need a space, comma, dash, or other character.
With “Maya” in A2 and “Chen” in B2, enter =A2&" "&B2 in C2. The formula returns “Maya Chen.” The quoted space is text supplied by the formula; it does not change either source cell. For a comma and space between the values, use =A2&", "&B2. If the result should read “Chen, Maya,” reverse the cell references.
After entering the formula, press Enter. To apply it 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 by row, so the formula copied to C3 refers to A3 and B3. Check the first few results, especially if the data includes blank cells or inconsistent formatting.
Use CONCAT or TEXTJOIN for other layouts
Excel also has functions for joining text. CONCAT is useful when you want to list cell references and separators as function arguments. With the first name in A2 and the last name in B2, =CONCAT(A2," ",B2) returns “Maya Chen.” CONCAT is available in modern Excel versions, including Microsoft 365. The ampersand remains a simple alternative for just two values.
TEXTJOIN is particularly handy when combining a range that may contain blank cells. With values in A2:C2 and a space as the separator, =TEXTJOIN(" ",TRUE,A2:C2) returns the nonblank values with spaces between them. For example, if A2 is “Maya,” B2 is blank, and C2 is “Chen,” the result is “Maya Chen,” with no extra leading or repeated space. The TRUE argument tells TEXTJOIN to ignore empty cells.
TEXTJOIN, CONCAT, and the ampersand create a result in the formula cell; none of them merges the source cells’ layout. These functions are helpful when you have multiple pieces of text or want to avoid awkward separators around blank cells. TEXTJOIN is available in Microsoft 365 and newer Excel versions; if a workbook will be opened in an older edition, check function compatibility before sharing it.
Keep the result updated or make it permanent
A formula-based result updates when one of its referenced cells changes. That is usually desirable for names, addresses, product labels, and other data that may be corrected later. It also means the combined text is not an independent, fixed value: it depends on the source cells and the formula remaining in place.
If you need a fixed result, copy the formula cells and paste their results as values. In Excel for Microsoft 365 on Windows, select the result range, press Ctrl+C, then use Home > Paste > Paste Values. The pasted text no longer changes when the original cells change. Keep a copy of the source data if you might need to edit or separate the original parts later.
Another option is to leave the formula in place and hide the source columns, but do that only when hiding the source is appropriate for the workbook. Hidden data is still present and can be unhidden. For a shared or audited workbook, clear headings and a note about how the combined field is produced may be more useful than concealing the original values.
Insert separators and handle blank cells
Decide what should appear between the two pieces before building the formula. A space suits full names; a comma and space often suit “City, State”; and a hyphen may suit a code or range. The separator is part of the output text, so a misplaced space or punctuation mark can affect sorting, matching, or later imports.
With A2 and B2 holding two values, =A2&" - "&B2 inserts a space, hyphen, and space between them. For “Room” in A2 and “12” in B2, the result is “Room – 12.” If either cell may be blank, a fixed separator can leave an unwanted mark at the start or end. TEXTJOIN can avoid separators around empty cells when combining a range, as long as its ignore-empty argument is set to TRUE.
Be aware that a cell that looks blank may contain a formula returning an empty string or spaces typed by a user. Extra spaces can make two results look identical while behaving differently in comparisons. If the output will be used for matching or importing, inspect the source values and decide whether trimming or cleaning them is necessary. Do not remove meaningful punctuation or spaces from data just to make a display look neater.
Merge cells for appearance without losing useful data
If you genuinely need one larger cell for a heading, first make sure only the upper-left cell contains information. Select the adjacent cells, then on the Windows ribbon choose Home > Merge & Center ▼ > Merge Cells to merge without centering the text. Choose Merge & Center if you want the text centered as well. The dropdown also includes options such as Unmerge Cells.
Excel displays a warning if more than one selected cell contains data, because the merge keeps only the upper-left value. Cancel and combine or move the contents first if you need to preserve them. Merging a range changes its structure and can complicate selecting, sorting, copying, or filling rows consistently. It is generally best reserved for presentation areas rather than the body of a data table.
In Excel for Mac, the corresponding merge controls are on the Home tab, though the ribbon layout can differ slightly by version and window size. Excel for the web also provides merge options on its Home tab. If a command is not visible, look for the Merge & Center dropdown in the Alignment group. The same data-loss caution applies across these versions.
Choose the method that fits the job
- Combine two values for use in another cell: use the ampersand or CONCAT, with an explicit separator where needed.
- Join several cells and skip blanks: use TEXTJOIN with an appropriate separator and TRUE for the ignore-empty argument.
- Make a heading span columns: use Merge & Center or Merge Cells only when the other selected cells do not hold data.
- Keep a stable, shareable data layout: leave values in separate columns and create a combined formula column if users need a display version.
For datasets, separate columns are often more useful than a single combined field. A full name stored as first name and last name can be sorted or filtered by either part, while the combined display can be generated when needed. Similarly, keeping street, city, and postal code separate makes it easier to validate and reuse each piece. A merged visual heading may be fine above a table, but merged cells inside the records can interfere with ordinary table operations.
Common problems and how to fix them
- The second value disappeared: the cells were probably merged rather than combined with a formula. Undo immediately with Ctrl+Z on Windows if possible, or restore the missing value from a saved copy. A formula cannot recover data that a merge has already discarded.
- The words run together: add a separator such as
" "between the references. A formula joins exactly what it is given; it does not infer where spaces belong. - The formula appears as text: check whether the cell is formatted as Text or whether an apostrophe was entered before the equals sign. Change the cell format to General, then re-enter the formula.
- The result shows an unexpected number format: joining a number to text converts the result to text, which may not preserve a desired date or decimal display. Use TEXT to specify a display format when needed, or format the source value appropriately before joining it.
- The formula does not update: confirm that calculation is set to Automatic under Formulas > Calculation Options, and check that the references point to the intended cells.
One subtle point is that a combined text value is not the same as a number that Excel can calculate with. For instance, joining a currency symbol and a numeric value produces text for display, not a numeric amount suitable for arithmetic. Keep the underlying numeric value in its own cell for calculations, and use a separate display formula only when a combined label is needed.
Frequently Asked Questions
Can I merge two Excel cells and keep both texts?
Not with the Merge Cells command: it retains the upper-left cell’s content and removes the other selected contents. First combine the values with a formula, or move them to another location, before merging if you need to preserve them.
What is the simplest formula to join two cells with a space?
If the text is in A2 and B2, use =A2&" "&B2 in another cell. It joins both values with one space and leaves the originals unchanged.
Can I combine cells without a formula?
You can copy the values into a new cell as text, but a formula is usually easier to update and fill down. If you need a fixed result, copy the formula output and use Paste Values.
Does Merge & Center combine the text?
No. It changes the cell layout and centers the retained value. If multiple selected cells contain content, Excel warns that only the upper-left cell’s value will remain.
How do I join cells while ignoring blanks?
With the values in A2:C2, use =TEXTJOIN(" ",TRUE,A2:C2). It places spaces between nonempty entries and ignores empty cells; TEXTJOIN is available in Microsoft 365 and newer Excel versions.
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
- Freeze a Group of Rows in Excel: Step-by-Step GuideTo keep several rows visible while you scroll in Excel for Microsoft 365 on Windows, select the first…
- How to Hide Columns in Excel for the Web: Steps & TipsTo hide columns in Excel for the web, select the column letter or letters, right-click the selection, and…
- Create a Cursive Signature in Outlook: Step-by-StepTo create a cursive signature in Outlook, add either script-style text or a picture of your handwritten signature…
- How to Share a Calendar in Outlook by Email or LinkTo share a calendar in Outlook, open Calendar, choose Share Calendar, add the person’s email address, set what…
- Excel Column to Comma-Separated List: Easy MethodsIf your values are in A2:A20, enter =TEXTJOIN(", ",TRUE,A2:A20) in an empty cell to turn the column into…
- Double Spacing in Microsoft Word: How to Set It UpTo set double spacing in Microsoft Word, select the text, then choose Home > Line and Paragraph Spacing…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.