Concat Excel Strings: Formulas and Practical Examples

Formulas & functions · Updated November 18, 2026

To concatenate strings in Excel, join cell values with the ampersand operator (&) or use CONCAT; use TEXTJOIN when you want a separator between several values. If A2 contains Liam and B2 contains Chen, this formula returns Liam Chen: =A2&" "&B2.

Concatenation means combining text into a single text result. It can join words, numbers, dates, or values from different cells without merging the cells themselves. The best formula depends on whether you need a simple join, a repeated delimiter, or control over blank cells.

Join two or more values with the ampersand

The ampersand is the quickest way to connect text in a formula. Put it between cell references, text in quotation marks, or both. To add a space or punctuation, include it as a quoted text fragment between the ampersands. The space in the first example is part of the formula; Excel will not insert one automatically.

With a first name in A2 and a last name in B2, use this formula to make a full name; for Liam and Chen, the result is Liam Chen: =A2&" "&B2.

You can join more than two cells by adding more ampersands. With a street name in A2, a city in B2, and a postal code in C2, this formula adds commas and spaces; for Oak Street, Fairview, and 02110, it returns Oak Street, Fairview, 02110: =A2&", "&B2&", "&C2.

Text typed directly into a formula needs straight double quotation marks. Cell references do not need quotation marks. You can also combine a label with a value: for example, a formula can produce a sentence such as “Order number: 1042” by joining a quoted label with a cell reference. The formula creates a text result; it does not change the original cells.

Use CONCAT to join cell references

CONCAT is Excel’s function for joining text. It can make a longer expression easier to read when you are combining several separate values. It does not add spaces, commas, or any other separator for you, so include those as arguments when you need them.

With Liam in A2 and Chen in B2, this formula returns Liam Chen: =CONCAT(A2," ",B2). The arguments are joined in order: the value from A2, one space, then the value from B2.

CONCAT can also accept a range. With words in A2:A4—North, Central, and West—this formula returns NorthCentralWest, with no separator: =CONCAT(A2:A4). If you want a delimiter between those cells, TEXTJOIN is usually clearer. CONCAT is available in Microsoft 365 and newer Excel versions; older workbooks may contain CONCATENATE, its earlier counterpart. CONCATENATE still works for compatibility, but CONCAT is the more flexible choice for joining ranges.

Add separators and skip blanks with TEXTJOIN

TEXTJOIN is useful when you are combining a list and want the same delimiter between each item. Its arguments specify the delimiter, whether to ignore empty values, and the values or ranges to join. In Microsoft 365, it is especially handy for names, addresses, tags, and other lists where some cells may be blank.

With A2:C2 containing North, a blank cell, and West, this formula joins the nonblank entries with a comma and a space; the result is North, West: =TEXTJOIN(", ",TRUE,A2:C2). TRUE tells Excel to ignore empty cells. Change it to FALSE if you want the delimiter positions preserved for empty entries.

TEXTJOIN uses the delimiter you provide between included values, not after the last value. A delimiter can be a space, comma, slash, or another text string. With department names in A2:A5, this formula separates each name with a vertical bar: =TEXTJOIN(" | ",TRUE,A2:A5). The same separator is applied consistently, rather than having to type it between every pair of cells as you would with ampersands.

TEXTJOIN is available in Microsoft 365 and Excel 2019 or later. If a workbook must work in an older Excel release that lacks the function, use ampersands for a small fixed number of cells or consider a compatible alternative appropriate to that version.

Keep dates, numbers, and identifiers readable

When Excel concatenates a number or date with text, it converts the value to text. That conversion may not use the display format you see in the cell. Dates can appear as serial numbers, and currency or percentage formatting may disappear. Use TEXT to specify a format when the displayed result matters.

With an invoice label in A2 and an actual Excel date in B2, this formula formats the date as an abbreviated month, day, and year; if B2 is November 2, 2026, the result is Invoice – Nov 2, 2026: =A2&" - "&TEXT(B2,"mmm d, yyyy"). The format pattern inside TEXT controls how the date is shown in the combined string.

With a product name in A2 and a numeric price of 12.5 in B2, this formula displays two decimal places; if A2 contains Widget, the result is Widget: $12.50: =A2&": "&TEXT(B2,"$#,##0.00"). The dollar sign and number pattern are formatting instructions for this text result; they do not change the underlying number in B2.

Product codes and other identifiers need special care. If a code such as 00073 is stored as a number, Excel may treat it as 73 and drop the leading zeros when joining it. With a numeric identifier in B2 that should display as five digits, this formula returns 00073: =TEXT(B2,"00000"). Where possible, store identifiers as text from the outset, especially if they are not quantities you intend to calculate.

Handle spaces, line breaks, and blank cells

Unwanted spacing is a common reason a concatenated result looks wrong. Check both the formula and the source values: a cell may already contain leading or trailing spaces, while the formula may add an extra space around a delimiter. TRIM can remove ordinary leading and trailing spaces and reduce repeated ordinary spaces between words.

With a first name in A2 and a last name in B2, this formula joins them with one space and trims extra ordinary spaces from the result; for values with accidental surrounding spaces, it returns a cleanly spaced full name: =TRIM(A2&" "&B2). TRIM does not remove every kind of invisible character, such as some nonbreaking spaces copied from websites. Those may need to be cleaned separately if they remain.

A blank cell and a cell containing a formula that returns an empty string are not always the same thing in every kind of formula. TEXTJOIN with TRUE is designed to ignore empty values, including empty text results in common cases, but it does not remove a separator that is part of the contents of another cell. If a result has extra punctuation, check whether the source cells contain spaces or punctuation themselves.

You can put a line break between two values by using CHAR(10). With an address line in A2 and a city line in B2, this formula puts the second value on a new line: =A2&CHAR(10)&B2. Turn on Wrap Text from Home > Wrap Text to display the break within the cell. The cell may also need its row height adjusted to show both lines.

Combine values from other sheets or add labels

Concatenation works with references to other worksheets as well as cells on the current sheet. If a sheet name contains spaces, Excel encloses the name in single quotation marks in the reference. With a first name in January!A2 and a last name in January!B2, this formula returns the full name with a space: ='January'!A2&" "&'January'!B2. If you rename or move referenced data, Excel may update the reference as appropriate, but it is still worth checking formulas after structural changes.

Labels can make a combined result easier to interpret. For instance, a report might display a customer name alongside an order status, or a date beside a descriptive phrase. Keep in mind that once you join different data types, the result is text. A date-and-label string may look like a date to a person but is generally not a date value that Excel can use directly for date arithmetic or chronological sorting.

If you need the combined output to remain current, leave the formula in place. If you need a fixed snapshot for export or sharing, copy the results and use Paste Special > Values. That replaces formulas with their displayed results, so later changes to the source cells will no longer update the copied text.

Choose the right method and understand the limits

For two or three values with a custom separator, the ampersand is compact and easy to adjust. CONCAT is convenient when joining several references or a range without a delimiter. TEXTJOIN is usually the clearest option for a range that needs a repeated separator or has blanks to skip. All three create a text result; none merges cells or changes the source data.

  • Use & when you want direct control over each part of a short expression.
  • Use CONCAT when you want to join values or a range without separators.
  • Use TEXTJOIN when you want one delimiter applied across many items and a choice about empty values.
  • Use TEXT within a concatenation when numbers or dates need a specific display format.

Concatenation is not the same as merging cells. Merge Cells is a layout feature that combines a cell area and can retain only the contents of the upper-left cell, potentially discarding other entries. A formula keeps the original values in separate cells and displays a combined result somewhere else. That is safer for sorting, filtering, calculations, and future changes to the source data.

Also distinguish a formula result from a permanent text value. A formula recalculates when its referenced cells change. A value pasted over the formula does not. Choose based on whether the combined string should remain linked to its source.

Common formula problems and fixes

If Excel shows the formula characters instead of the result, check that the cell is not formatted as Text and that the formula begins with an equals sign. Change the cell format to General, then re-enter the formula. Also check whether Show Formulas is turned on; that setting displays formulas across the worksheet instead of their results.

If the result has no spaces or commas, add the separator explicitly in quotation marks. For example, CONCAT(A2,B2) joins the contents directly, whereas CONCAT(A2,” “,B2) puts a space between them. If a date appears as a number, wrap the date reference in TEXT and specify the format you want. If leading zeros disappear, keep the identifier as text or format it with TEXT as appropriate.

In some regional settings, Excel uses a list separator other than a comma in formulas. Microsoft 365 for Windows normally follows the separators configured for the system, so a formula copied from a different locale may need its argument separators adjusted. The examples here use commas, as in standard English-language Excel syntax. The ampersand operator itself is not affected by argument separators.

On Excel for Mac, the same functions and basic formula patterns work. Ribbon and keyboard details can differ from Windows, and formula separators can depend on regional settings. Excel for the web also supports these standard concatenation functions, though the location of some commands and formatting controls may differ from the desktop ribbon.

Frequently Asked Questions

What is the simplest way to concatenate two cells in Excel?

Use the ampersand between the two cell references. Add a quoted space or punctuation between them if you want a separator. For example, the first-name and last-name example above returns a full name with one space.

What is the difference between CONCAT and TEXTJOIN?

CONCAT joins values without inserting a delimiter. TEXTJOIN lets you choose a delimiter and whether empty values should be ignored, which makes it more convenient for joining a list of cells.

How do I concatenate cells and add a space?

Put a space in quotation marks between the references, such as the pattern shown in the first section. Excel treats that quoted space as literal text in the result.

How do I concatenate a date without showing a number?

Use TEXT around the date reference to specify how it should appear, then join that formatted text to the other values. Choose a format pattern such as mmm d, yyyy to show a readable date.

Can I concatenate cells while ignoring blanks?

Yes. Use TEXTJOIN and set its ignore-empty argument to TRUE. It will join the nonempty entries using the delimiter you specify, which avoids many extra separators in incomplete lists.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.