To concatenate in Excel means to join text or values into one text string. In Microsoft Excel for Microsoft 365 on Windows, the quickest formula is the ampersand operator: if A2 contains a first name and B2 a last name, enter =A2&" "&B2 in C2 to return both names with a space between them. You can also use CONCAT for simple joining or TEXTJOIN when you need a separator between several items.
What concatenation means in Excel
Concatenation combines pieces of text in a chosen order. The pieces can come from cells, typed text, numbers, or formula results. For example, you might join a first and last name, assemble a street address from separate columns, or add a label to a calculated total. Concatenation does not add the values mathematically: joining 12 and 34 produces the text string “1234,” not the sum 46.
The result is generally text, even when the joined pieces look like a number or date. That matters if you intend to sort, calculate with, or use the result as a date later. Excel may display a joined string that looks numeric, but it is not automatically a numeric value suitable for arithmetic. Keep the original values in their own cells if you may need to calculate with them.
There are three practical choices for most worksheet tasks:
- & joins a small number of pieces and gives you direct control over each separator.
- CONCAT joins text and cell ranges without inserting separators.
- TEXTJOIN joins multiple pieces with a separator and can skip empty cells.
Join two cells with the ampersand operator
The ampersand is often the easiest method to read and edit. With first names in A2:A20 and last names in B2:B20, enter the following formula in C2, then fill it down. For a row where A2 is “Ada” and B2 is “Lovelace,” the result is “Ada Lovelace.”
With the first name in A2 and the last name in B2, use =A2&" "&B2.
The quoted space is a literal separator. Without it, =A2&B2 would return “AdaLovelace.” You can put other literal text in quotation marks as well. For example, a comma and a space can separate a city and state, while a hyphen can separate a product code’s parts. The ampersand connects each piece in the order you write it, so you can mix cell references and fixed text in one expression.
With a first name in A2 and a last name in B2, this equivalent formula uses CONCAT: =CONCAT(A2," ",B2). It returns “Ada Lovelace” for the same example. Use whichever form is clearest to the people who will maintain the workbook; the ampersand is compact, while CONCAT makes the joining operation explicit.
Use CONCAT for a range or several pieces
CONCAT is a modern replacement for the older CONCATENATE function in many ordinary tasks. It can join individual arguments or a range, but it does not add spaces, commas, or other separators for you. If the range A2:C2 contains “North,” “Central,” and “Office,” a formula that joins the range directly returns “NorthCentralOffice.” You must include separator text yourself when you want it.
With the three pieces in A2:C2 and a space required between each one, enter =CONCAT(A2," ",B2," ",C2). If the cells contain “North,” “Central,” and “Office,” the result is “North Central Office.” For longer ranges, TEXTJOIN is usually more convenient because it applies one delimiter repeatedly rather than requiring you to add a separator between every cell reference.
CONCATENATE remains available in Excel for compatibility with older workbooks, but Microsoft recommends CONCAT for new formulas. Existing formulas using CONCATENATE do not need to be rewritten just because the function is older. The main practical distinction is that CONCAT can accept a range as an argument, while CONCATENATE is typically used with individual text arguments. Neither function automatically inserts a delimiter.
Add separators and skip blanks with TEXTJOIN
TEXTJOIN is useful for lists because it takes a delimiter, a setting for empty cells, and the text or range to combine. With names or other items in A2:C2, this formula joins the nonempty cells using a comma and a space: =TEXTJOIN(", ",TRUE,A2:C2). If A2:C2 contains “red,” a blank cell, and “blue,” the result is “red, blue.” The TRUE argument tells Excel to ignore empty cells.
Change the first argument to choose another separator. For example, a space produces a readable phrase, a line break can separate items within a cell, and a slash can join month and year components. For a line break, use =TEXTJOIN(CHAR(10),TRUE,A2:C2) with the values in A2:C2; the result puts each nonempty value on a separate line inside the cell. Turn on Home > Wrap Text to display those line breaks visibly. CHAR(10) represents a line-feed character.
If you set the second argument to FALSE, TEXTJOIN preserves the positions of empty cells by including delimiters for them. This can be useful when empty positions carry meaning, but it can also create repeated separators. Be aware that “empty” is not always the same as a cell that looks blank: a cell containing a formula that returns an empty string may behave differently from a truly empty cell in some formula contexts. Check the actual source cells when the output is surprising.
Keep dates, numbers, and codes readable
When Excel combines a date or number with text, it may use the underlying value rather than the way the cell is displayed. A date stored as a serial number, for example, can appear as a number in a concatenated result. Use TEXT to specify the display format as part of the formula. With a name in A2 and a date in B2, enter =A2&" - "&TEXT(B2,"mmm d, yyyy"). If A2 is “Alex” and B2 contains March 5, 2026, the result is “Alex – Mar 5, 2026.”
The format pattern inside TEXT determines how the value appears in the joined string. Common date patterns include “yyyy-mm-dd” for a year-month-day format and “mmmm d, yyyy” for a full month name. Format codes can be affected by regional settings, so a workbook opened with different language or locale settings may display month names or separators differently. If a fixed, locale-independent format is important, use a numeric date pattern such as yyyy-mm-dd and verify the workbook in its intended environment.
Leading zeros are another common issue. If A2 contains the number 27, a custom display format in the cell does not always carry through when you concatenate it. With the code number in A2, use =TEXT(A2,"00000") to produce the text “00027.” To add a prefix as well, use ="ID-"&TEXT(A2,"00000"), which returns “ID-00027.” Store identifiers as text when possible if they are not quantities for calculation; that avoids losing leading zeros during data entry or import.
Fill the formula down and manage the results
After entering a formula in the first row, use the fill handle at the lower-right corner of the selected cell to copy it to adjacent rows. Excel adjusts relative references as it fills: a formula referring to A2 and B2 changes to A3 and B3 in the next row. You can also select the formula cell and the cells below it, then use Ctrl+D on Windows to fill down. On Mac, the equivalent shortcut is Control+D in Excel; keyboard mappings can vary with system settings, so the Fill command on the Home tab is an alternative.
If you need a joined result that will not change when the source cells change, copy the results and paste values. In Excel for Microsoft 365 on Windows, use Home > Paste > Values from the Paste menu. This replaces the formulas with their current displayed text. Consider keeping a copy of the source data first: once you replace formulas with values, the cells no longer update automatically.
Excel formulas recalculate when their referenced inputs change, so concatenation is useful for labels that should stay synchronized with worksheet data. However, a long joined string is subject to Excel’s cell text limit of 32,767 characters. If your source data may exceed that size, consider whether it belongs in a cell at all or should instead remain in separate rows or columns.
Common problems and how to fix them
- The result has no spaces. Add a quoted space, such as
" ", between the references. Excel does not infer word boundaries. - A date becomes a serial number. Wrap the date cell in TEXT and supply the format you want, as in the date example above.
- There are extra commas or spaces. Use TEXTJOIN with TRUE to skip empty cells, or clean the source data and check whether cells contain spaces rather than being genuinely empty.
- Leading zeros disappear. Keep identifiers as text or use TEXT with a zero format pattern before joining.
- The formula displays instead of calculating. Check that the cell is not formatted as Text, and make sure the formula begins with an equals sign. If needed, change the number format to General and re-enter the formula.
- Excel shows a formula error after pasting. Confirm that quotation marks are straight double quotes and that commas match the list separator expected by your regional settings. Excel installations configured for some locales use semicolons as formula separators; if the formula was copied from a comma-based example, replace separators as required by that installation.
Also remember that concatenation does not trim accidental spaces. If a source value has a trailing space, joining it to another value can make the result look as if the separator is doubled. TRIM can remove ordinary leading and trailing spaces from text, but it does not remove every possible invisible character, such as nonbreaking spaces copied from a web page. Inspect and clean imported values when the visible result does not match the source data.
Choose between formulas and Flash Fill
Use a formula when the output must update as source data changes, when the joining rule needs to be repeatable, or when you want one consistent method across many rows. CONCAT is a straightforward choice for a range with no delimiter; TEXTJOIN is more suitable for a range that needs a consistent separator or blank-cell handling. For just two or three pieces, the ampersand is often the clearest option.
Flash Fill is an alternative when you want Excel to infer a text pattern and produce fixed results rather than live formulas. In Excel for Microsoft 365 on Windows, enter an example of the desired combined value in the first row, then use Data > Flash Fill or press Ctrl+E. Review the filled results: Flash Fill recognizes a pattern from examples, and it may not infer your intended rule correctly in every data set. On Mac, use Data > Flash Fill if available in your Excel version; menu availability and shortcuts can differ. Unlike a formula, a Flash Fill result does not automatically update when the source values change.
For a one-time cleanup, a formula followed by Paste Values can be more transparent than pattern detection. For recurring imports or complex transformations, Power Query may be a better fit because it can apply repeatable data-cleaning steps before loading results into a worksheet. The right method depends on whether you need live updates, a reusable process, or simply a fixed text result.
Frequently Asked Questions
Is CONCAT the same as CONCATENATE in Excel?
They both join text without inserting separators. CONCAT is the newer function and can accept a range; CONCATENATE is retained mainly for compatibility with older workbooks. For new formulas, CONCAT or the ampersand operator is usually preferable.
How do I concatenate cells with a comma and a space?
For a short list, place the comma and space in quotation marks between references. For a range, TEXTJOIN is simpler: set its first argument to a comma followed by a space, and choose whether empty cells should be ignored.
Can I concatenate a range without getting extra separators?
Yes. Use TEXTJOIN and set its ignore-empty argument to TRUE. It skips empty cells while placing the chosen delimiter between included values. Check whether apparently blank cells contain spaces or formulas, because those may not behave like truly empty cells.
Why does my concatenated date look like a number?
Excel stores dates as serial values. When joining a date with other text, explicitly format it using TEXT, for example with a pattern such as “mmm d, yyyy.” The format you choose becomes part of the resulting text.
Can I concatenate cells and still calculate with the result?
A concatenated result is text, so it is not a dependable substitute for the original numeric or date values in calculations. Keep the source values in separate cells and use them for arithmetic; create a joined display string only where a readable label is needed.
Related
- Print Excel Sheets With Gridlines: Steps and Tips
- Can You Protect Cells in Excel? A Practical Guide
- Print an Excel Spreadsheet: Setup, Pages, and Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Shortcut for Removing a Filter: What WorksIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter off or on; this removes the…
- Excel Text Filter Multiple Values: How to Do ItTo filter for multiple text values in Excel, open the column’s filter menu and select each value you…
- Excel Filter Multiple Criteria in One Column: 5 MethodsTo filter one Excel column by multiple criteria, open its filter dropdown and select several values, or choose…
- Excel Table Filter by Multiple Colors: What WorksIn Excel for Microsoft 365 on Windows, a table’s color filter can show rows for one selected fill…
- Excel Formula Color: How to Use Conditional FormattingYou cannot make a standard Excel formula directly change a cell’s font or fill color. To color cells…
- How to Find the Lowest Number in Excel with MIN FormulaTo find the lowest number in a range, enter =MIN(A2:A20) in an empty cell, replacing A2:A20 with the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.