You can combine text in Excel with the ampersand operator (&), CONCAT, or TEXTJOIN; for example, with a first name in A2 and a last name in B2, enter =A2&" "&B2 in C2 to display both names with a space between them. If you mean combining cells visually, use Merge & Center; if you mean combining whole tables, Power Query is usually the better tool.
Choose the right kind of combining
“Combine” can describe several different tasks in Excel, and the right method depends on what you want the result to do. Joining values into a text string creates a new value, usually in another cell. Merging cells changes the layout of a worksheet. Combining tables brings rows or columns from separate data sources together for analysis.
- Join text or values: use
&, CONCAT, or TEXTJOIN to build a result in a formula cell. - Join cells visually: use Merge & Center or a related merge option, usually for headings rather than data tables.
- Combine datasets: use Power Query to append rows or merge tables using a matching column.
These approaches are not interchangeable. A formula can join two names into one display value without changing the original cells. Merging cells, by contrast, can discard content in cells other than the top-left cell. Power Query creates a structured result that can be refreshed when its source data changes.
Combine text with the ampersand operator
The ampersand is a straightforward way to join cell contents and fixed text. It works in current Excel versions and is convenient when you know exactly which cells and separators you need. Put the formula in a blank cell, then copy it down to apply the same pattern to other rows.
With a first name in A2 and a last name in B2, enter =A2&" "&B2 in C2. If A2 contains Maya and B2 contains Chen, the displayed result is Maya Chen. The quoted space is a literal separator; without it, the result would be MayaChen.
You can add labels and punctuation in the same way. With a product name in A2 and a quantity in B2, enter =A2&" ("&B2&" units)" in C2. If A2 is Notebook and B2 is 4, the result is Notebook (4 units). Text that you type directly into a formula must be enclosed in straight double quotation marks.
To fill the formula down, select the formula cell and drag its fill handle, or double-click the handle when adjacent rows contain data. Excel adjusts relative references as it copies: the formula in C3 will refer to A3 and B3. If you need a reference to stay fixed while copying, use dollar signs, as in $A$2.
Use CONCAT or TEXTJOIN for longer combinations
CONCAT joins text from multiple cells or ranges, but it does not insert separators automatically. With first name in A2, a middle initial in B2, and last name in C2, enter =CONCAT(A2," ",B2," ",C2) in D2. If the cells contain Maya, R, and Chen, the result is Maya R Chen. This function is available in Microsoft 365 and Excel 2019 or later.
TEXTJOIN is often more convenient when you want the same delimiter between several values, especially when some cells may be blank. With A2:C2 containing Maya, a blank cell, and Chen, enter =TEXTJOIN(" ",TRUE,A2:C2) in D2. The result is Maya Chen: the first argument supplies the space delimiter, and TRUE tells Excel to ignore empty cells. TEXTJOIN is available in Microsoft 365 and Excel 2019 or later.
For a list separated by commas, with values in A2:A5, enter =TEXTJOIN(", ",TRUE,A2:A5) in B2. If the nonblank cells contain red, blue, and green, the result is red, blue, green. If you set the second argument to FALSE, Excel includes an empty position, which can produce consecutive delimiters. Choose TRUE when blanks should be skipped.
Older workbooks may contain CONCATENATE, a legacy function that joins text, but CONCAT or the ampersand is generally clearer for new formulas. CONCATENATE does not provide TEXTJOIN’s delimiter and ignore-empty options. If a workbook must be opened in an older Excel version, check function compatibility before relying on newer functions.
Preserve number and date formatting
When a formula joins a number or date to text, Excel may show the underlying value rather than the format you see in the original cell. For instance, a date displayed as 3-Nov-2026 can appear as a serial number when directly concatenated. Use TEXT to specify how the value should appear in the combined result.
With an event name in A2 and a date in B2, enter =A2&" — "&TEXT(B2,"d mmm yyyy") in C2. If A2 contains Review and B2 contains the date November 3, 2026, the result is Review — 3 Nov 2026. The date format inside TEXT controls its appearance in the joined text; it does not change the date stored in B2.
For a price, with an item name in A2 and a numeric price in B2, enter =A2&": $"&TEXT(B2,"0.00") in C2. If A2 is Pen and B2 is 1.5, the result is Pen: $1.50. Pick a format that suits the values and the workbook’s regional settings; currency symbols and date conventions may differ between locations.
Combine cells without a formula
If the goal is a single display cell rather than a reusable formula, Flash Fill can recognize a pattern from examples. Suppose A2 contains Maya and B2 contains Chen. Type Maya Chen in C2, start entering the next combined name in C3, and use Data > Flash Fill, or press Ctrl+E on Windows. Excel attempts to fill the remaining rows based on the pattern. Review the output, especially if the source values are inconsistent. Flash Fill creates values rather than formulas, so later edits to the source cells do not automatically update its results.
Another one-time option is to copy a formula-generated result and paste it as values. Copy the formula cells, then use Home > Paste > Values. This leaves the displayed text in place without a live formula. It can be useful before sharing a static export, but the pasted values will not respond to changes in the original cells.
Do not confuse either method with Merge & Center. To merge cells, select the cells and choose Home > Merge & Center; use the dropdown beside the command for other merge options. Excel retains the content of the upper-left cell and removes the contents of the other selected cells. Copy or join those values first if they matter. Merged cells can also make sorting, filtering, and selecting a consistent data range harder, so avoid them inside ordinary data tables.
Combine rows or columns with Power Query
When “combine” means bringing complete datasets together, Power Query can create a result that is easier to refresh and maintain than a long chain of cell formulas. In Excel for Microsoft 365 on Windows, you can import supported sources from Data > Get Data. For example, use Data > Get Data > From File > From Workbook to import data from another workbook, or choose From Folder to work with files in a folder.
Power Query offers two different operations. Append stacks rows from one table beneath rows from another, much like adding records to a list. Merge matches rows across tables using one or more columns in common, much like looking up related details. A customer list and an orders list, for example, might be merged on a customer ID; two monthly sales tables with the same columns might be appended.
To append existing queries, open the queries in Power Query Editor and choose Home > Append Queries or Home > Append Queries as New. The first option modifies a query; the second creates a separate query. Choose the tables to append, check that their column names and data types make sense, and then use Home > Close & Load to return the result to Excel. When the source changes, refresh the query to update its output.
To match records, choose Home > Merge Queries or Home > Merge Queries as New in Power Query Editor, select the related columns in both tables, and choose the join kind. A left outer join keeps all rows from the first table and brings in matching values from the second; unmatched rows have blank results for the second table’s fields. Check that the chosen key identifies the intended records. Duplicate keys can create multiple matched rows, while mismatched data types or extra spaces can prevent expected matches.
For files with the same structure in one folder, importing from a folder can help consolidate them, but first check that the files have compatible columns and headers. Excel’s exact import options can vary by source and platform. The Windows paths above describe Microsoft 365 for Windows; Power Query features and menus differ in Excel for Mac and Excel for the web, so check the commands available in your version.
Choose a method and avoid common problems
Use a formula when the combined result should update as the source cells change. Use Flash Fill or paste values when you need a one-time result. Use Power Query when the task involves repeatable imports, multiple tables, or more records than you would sensibly assemble by hand. Merge cells only when the layout itself needs a heading that spans a region.
- Unexpected spaces: add a deliberate separator such as
" ", or clean source values that contain leading or trailing spaces. - Missing parts of a result: check whether the source cells are blank and whether TEXTJOIN is set to ignore empty cells.
- Dates or numbers look wrong: use TEXT with a suitable number format when combining them with text.
- Formula shows literally: check that the cell is not formatted as Text, and that the formula begins with an equals sign.
- Merge loses information: remember that only the upper-left cell’s contents are retained when cells are merged.
- Power Query has unexpected matches: inspect key columns for duplicates, inconsistent types, and extra spaces.
A common misconception is that joining cells with a formula combines the underlying records permanently. It does not: a formula displays a result while the original cells remain separate. Likewise, appending tables is not the same as merging them by a key. If you need a dependable dataset for sorting, filtering, or analysis, preserve a clear table structure and use Power Query or formulas designed for that purpose rather than joining everything into one text cell.
Frequently Asked Questions
What is the easiest way to combine two cells in Excel?
For a simple result that updates automatically, use the ampersand. With the values in A2 and B2 and a space between them, enter =A2&" "&B2 in another cell. Replace the quoted space with a comma, hyphen, or other separator as needed.
How do I combine cells and keep a space between words?
Include a space in quotes between the cell references, such as =A2&" "&B2. For several cells with one consistent delimiter, TEXTJOIN can be more convenient and can skip blank cells.
Does Merge & Center combine the text in cells?
No. It combines the selected cells into a larger cell area but keeps only the upper-left cell’s content. To retain all the text, join it with a formula first, or use a suitable data-combination method instead.
How can I combine multiple Excel sheets?
If each sheet contains rows with the same column structure, import the tables into Power Query and append the queries. If the sheets hold related columns that should be matched by an ID, merge the queries instead. For a small, one-time task, copying and pasting may be sufficient, but check headers and data types.
Will a combined formula update when the original cells change?
Yes. A formula such as the ampersand example recalculates when its referenced cells change. Flash Fill and pasted values are static results, while a Power Query output updates when you refresh the query.
Related
- Can You Shade Half a Cell in Excel? Options Explained
- Can You Shuffle Names in Excel? Methods and Examples
- Can You Copy an Excel Spreadsheet? Methods Explained
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Keep Duplicate Values in Excel Without Losing DataTo keep repeated entries in Excel, do not run Data > Remove Duplicates on the data you need…
- Custom Freeze Panes in Excel: How to Set ThemTo create custom freeze panes in Excel for Microsoft 365 on Windows, select the cell immediately below the…
- Excel Goal Seek Precision: Accuracy and LimitsExcel Goal Seek can find an input value that makes a formula reach a target, but it does…
- Excel Slicer: Connect One Slicer to Multiple PivotTablesYes. In Excel for Microsoft 365 on Windows, one slicer can filter multiple PivotTables when they share a…
- Excel Shortcut Keys to Change Sheets: Windows and MacIn Excel for Microsoft 365 on Windows, press Ctrl+Page Up to move to the previous worksheet, or Ctrl+Page…
- Google Sheets: Conditional Formatting for DuplicatesYes. In Google Sheets, you can highlight duplicate values with a custom conditional-formatting rule: select the cells, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.