Besides the ampersand (&), you can join text in Excel with CONCAT, TEXTJOIN, or the older CONCATENATE function; for repeatable cleanup, Flash Fill and Power Query can also combine text without a worksheet formula. Choose based on whether you need a separator, want to join a range, or need the result to update automatically when source cells change.
What concatenation means in Excel
Concatenation simply means joining pieces of text into one result. The pieces can be typed directly into a formula, stored in cells, or returned by other functions. Common jobs include combining first and last names, assembling addresses, adding labels to numbers, and creating readable descriptions from data in separate columns.
Concatenation does not automatically add spaces or punctuation. If A2 contains Ada and B2 contains Lovelace, joining the cells directly produces AdaLovelace. You must include a space, comma, hyphen, or other separator wherever it belongs. Also, concatenating a value into text generally turns the result into text, which is useful for labels but not ideal if you later need to calculate with the combined result as a number or date.
Use the ampersand operator
The ampersand (&) is the simplest alternative to a dedicated function and works in current Excel versions. It joins text, cell references, and fixed text in the order you write them. With Ada in A2 and Lovelace in B2, enter this formula in C2:
Assuming A2 contains Ada and B2 contains Lovelace: =A2&" "&B2 returns Ada Lovelace.
Quotation marks identify literal text in a formula. That means a space must be written as ” “, while a comma and space can be written as “, “. To create a label before a value, place the label in quotation marks and join it to the cell. The ampersand is especially handy when only a few pieces are being combined, or when you want to see the order of the pieces at a glance.
You can also join more than two items by repeating the operator. For an address, that may mean street, city, and postal code with punctuation between them. Keep separators inside quoted strings; otherwise Excel may interpret punctuation as part of the formula syntax.
Use CONCAT for cells and ranges
CONCAT is the modern function for joining text and can accept individual cell references or a range. Unlike the ampersand approach, it can make a formula that joins a whole range without listing every cell separately. CONCAT does not insert a delimiter, so spaces or punctuation must still be supplied as separate arguments when needed.
Assuming A2 contains North, B2 contains a hyphen, and C2 contains South: =CONCAT(A2:C2) returns North-South.
For two names with a space between them, an explicit separator works too. Assuming A2 contains Ada and B2 contains Lovelace: =CONCAT(A2," ",B2) returns Ada Lovelace. CONCAT is available in Microsoft 365 and newer perpetual Excel releases, including Excel 2019 and later. If a workbook must also work in an older Excel version, check compatibility before replacing older formulas.
Use TEXTJOIN when you need a delimiter
TEXTJOIN is often the most convenient choice for lists because it applies one delimiter between items and can optionally skip empty cells. Its arguments specify the delimiter, whether to ignore empty cells, and the text or range to join. For example, a comma-and-space delimiter can turn a row of entries into a readable list.
Assuming A2 contains red, B2 is empty, and C2 contains blue: =TEXTJOIN(", ",TRUE,A2:C2) returns red, blue. The TRUE argument tells Excel to ignore empty cells, so the blank B2 does not create an extra comma.
Set the ignore-empty argument to FALSE when empty positions must be retained. That can be useful when the position of each field matters, though consecutive delimiters may look untidy. TEXTJOIN is available in Excel 2019 and later, including Microsoft 365. It is a strong choice for variable-length lists, while CONCAT or & may be simpler for a small fixed set of pieces.
Keep numbers, dates, and formatting readable
When a number or date is joined to text, Excel uses the underlying value, which may not match the display format you see in the cell. For instance, a date displayed as 3-Nov-2026 can appear as a serial number in a concatenated result. Use TEXT to specify how that value should look before joining it.
Assuming A2 contains the label Total, and B2 contains the numeric value 1250: =A2&": "&TEXT(B2,"$#,##0.00") returns Total: $1,250.00.
The format pattern in TEXT controls presentation, not the stored value. Adjust it for the number of decimal places, currency symbol, or date style you need. For a date in B2, for example, a TEXT format such as “mmm d, yyyy” can produce a readable date inside a sentence. Regional settings can affect how dates and currency are displayed, so choose a format appropriate for the workbook’s audience. If the combined result is meant to remain a number for calculations, keep the numeric value in its own cell instead of turning it into a text label.
Try CONCATENATE for older workbooks
CONCATENATE is the older function name that many existing workbooks still use. It joins individual arguments, but it does not offer CONCAT’s convenience for a range or TEXTJOIN’s delimiter and ignore-empty options. Microsoft retains it for compatibility, so there is usually no need to change a working formula simply because a newer function exists.
Assuming A2 contains Ada and B2 contains Lovelace: =CONCATENATE(A2," ",B2) returns Ada Lovelace. For new formulas, CONCAT or the ampersand operator is generally clearer; use TEXTJOIN when separators and blank cells are part of the problem. If you share files with people using older Excel, test any newer function in the oldest version that needs to open the workbook.
Combine text without a formula
Flash Fill can recognize a pattern from an example and fill the remaining rows. It is useful when you need a one-time result rather than a live formula. Suppose first names are in column A and last names in column B. Type the correctly spaced full name in the first result cell, select the next result cell, and choose Data > Flash Fill. On Windows, Ctrl+E is the Flash Fill shortcut. On Mac, use Data > Flash Fill where available; keyboard shortcuts can differ by Excel version and keyboard settings.
Flash Fill produces values rather than formulas. If the source names change later, its results do not automatically recalculate. Review the filled output, especially if source entries are inconsistent, because Excel is inferring a pattern from examples rather than applying a rule you have explicitly defined.
Power Query is another option when you repeatedly import and reshape data. In Excel for Microsoft 365 on Windows, format the source as a table, then choose Data > From Table/Range. In the Power Query Editor, choose Add Column > Custom Column and build a text expression from the relevant columns, inserting a quoted separator where needed. After checking the preview, choose Home > Close & Load to return the result to Excel. On Mac and Excel for the web, Power Query features and available commands can differ; use the version’s Data tab to confirm that the editor and required options are available. Unlike a normal cell formula, a query result is refreshed through the query rather than recalculated as you edit individual source cells.
Choose the right method for the job
There is no single best way to concatenate in every workbook. Match the method to how much data you have, whether the output must update, and who will open the file. These practical guidelines help narrow the choice:
- Use & for a short, fixed formula with a few cells and custom separators.
- Use CONCAT to join multiple cells or a range when no delimiter is needed, or when you want to specify separators yourself.
- Use TEXTJOIN for a range that needs a consistent delimiter and may contain blank cells.
- Keep CONCATENATE when maintaining an older workbook or when changing a legacy formula offers no benefit.
- Use Flash Fill for a one-time transformation that does not need to stay linked to its source.
- Use Power Query for a repeatable import-and-transform process, particularly when the same preparation is needed after each refresh.
For dynamic worksheet results, formulas are usually easiest to audit and update. For manual cleanup, Flash Fill can be faster. For recurring data preparation, Power Query makes the transformation part of a refreshable workflow. These approaches solve related problems, but their outputs behave differently: a formula recalculates, Flash Fill creates fixed values, and a query updates when refreshed.
Common concatenation problems
A missing space is the most common surprise. Check that the formula includes a quoted separator between the relevant pieces. Extra spaces often come from the source data itself; TRIM can help clean ordinary leading and trailing spaces, though it does not remove every kind of whitespace. If data comes from a website or another system, nonbreaking spaces may need separate cleanup.
Another frequent issue is an unexpected number or date display. Excel stores dates as numbers, and a cell’s visual formatting is not automatically carried into a text result. Wrap the value in TEXT with a deliberate format when the result must be readable. Similarly, a leading zero in a code may be lost if Excel has treated the code as a number. Preserve identifiers such as postal codes or account codes as text when possible, because they are labels rather than quantities.
Finally, concatenated output is text. A result that looks like a date or number may not behave like one in sorting, arithmetic, or date calculations. Keep the original fields in separate columns when downstream analysis matters, and create a combined display column only as needed. This avoids sacrificing useful structure just to make a cell look more convenient.
Frequently Asked Questions
What is the simplest way to concatenate in Excel?
The ampersand (&) is usually simplest for joining a few cells. Add quoted text between references when you need spaces or punctuation.
What is the difference between CONCAT and TEXTJOIN?
CONCAT joins the supplied text or range without adding separators. TEXTJOIN applies a chosen delimiter and can skip empty cells, making it especially useful for lists.
Can I concatenate cells and keep a space between them?
Yes. Include a space as quoted text between the cell references, whether you use &, CONCAT, or CONCATENATE. TEXTJOIN can also use a space as its delimiter.
Why does a concatenated date show as a number?
Excel stores dates as serial values, and concatenation may use that underlying value instead of the cell’s display format. Use TEXT with a date format to control how the date appears in the joined result.
Does Flash Fill update when I change the original cells?
No. Flash Fill creates fixed values, not formulas. Use a worksheet formula for results that should recalculate when source cells change.
Related
- Microsoft Excel Employee Schedule Template: Setup Tips
- Microsoft Excel Debt Payoff Template: Build a Reliable Plan
- Microsoft Excel Custom Number Formats: A Practical Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Filters: How to Add and Use ThemTo add a filter in Google Sheets in a web browser, select your data range, including its header…
- How to Zoom in Microsoft Excel: Quick Ways to ResizeTo zoom in Microsoft Excel on Windows, use the zoom slider at the bottom-right of the Excel window,…
- Highlight Duplicates in Excel Table: A Step-by-Step GuideTo highlight repeated values in an Excel table, select the cells to check, then choose Home > Conditional…
- Remove Strikethrough in Excel Numbers and CellsTo remove strikethrough from a number in Excel for Microsoft 365 on Windows, select the cell and press…
- Excel Shortcut Keys With Ctrl, Alt, and Shift ExplainedExcel has several useful shortcuts that combine Ctrl, Alt, and Shift, but there is no single shortcut that…
- Excel: How Many Complete Months Are Between Two Dates?To find the number of complete months between two dates in Excel, use =DATEDIF(A2,B2,"m"), with the earlier date…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.