Excel Concatenate String Examples: Formulas That Work

To concatenate strings in Excel, join cell references and text with the ampersand operator (&), or use CONCAT or TEXTJOIN. For example, if A2 contains Maria and B2 contains Chen, =A2&" "&B2 returns Maria Chen. The ampersand method is a clear choice for short combinations; TEXTJOIN is useful when you need a delimiter between many cells and want to skip blanks.

What concatenation means in Excel

Concatenation means joining text pieces together in a sequence. Those pieces can be words typed into a formula, values from cells, or results returned by other formulas. The result is one text string in a cell; concatenation does not combine cells physically, merge their formatting, or change the original values.

Excel has several ways to build a string. The ampersand operator is concise and works well for most everyday formulas. CONCAT combines text and ranges. CONCATENATE is an older function that remains available for compatibility with existing workbooks. TEXTJOIN adds a chosen separator and can ignore empty cells. All of these are useful, but they do not insert spaces or punctuation automatically: you must specify those when needed.

Quick examples with the ampersand operator

For simple combinations, use & between each value. Any fixed text, including a space or punctuation mark, must be enclosed in straight double quotation marks. These examples assume Microsoft Excel for Microsoft 365 on Windows; the formulas also work in current Mac and web versions of Excel.

With a first name in A2 and a last name in B2, =A2&" "&B2 returns Maria Chen when the cells contain Maria and Chen.
With a product name in A2 and a code in B2, =A2&" ("&B2&")" returns Notebook (A17) when the cells contain Notebook and A17.
With a city in A2, a comma and space as the separator, and a state in B2, =A2&", "&B2 returns Austin, TX when the cells contain Austin and TX.

For the first example, with the first name in A2 and the last name in B2, enter =A2&" "&B2 in C2. If A2 contains Maria and B2 contains Chen, C2 displays Maria Chen. The formula keeps referencing the source cells, so changing either name updates the result. To use it for more rows, drag the fill handle at the lower-right corner of C2 down the column; Excel adjusts the row references automatically.

With a first name in A2, a last name in B2, and a city in C2, =A2&" "&B2&" — "&C2 returns Maria Chen — Austin when those cells contain Maria, Chen, and Austin. This illustrates why the operator is convenient for labels and messages: you can place fixed text wherever it belongs in the sequence.

Using CONCAT and CONCATENATE

CONCAT is a function that joins text from individual arguments or a range. With North in A2, wind in B2, and 12 in C2, =CONCAT(A2:C2) returns Northwind12. It combines the values in order, but it does not insert spaces or other separators. To add a space between the first two cells, with the same layout, use =CONCAT(A2," ",B2,C2); the result is North wind12.

CONCATENATE uses a similar argument pattern and is retained so older workbooks continue to calculate. With Maria in A2 and Chen in B2, =CONCATENATE(A2," ",B2) returns Maria Chen. For new formulas, CONCAT or & is usually easier to read, especially when there are several pieces. CONCATENATE does not provide a special advantage for inserting separators; you still have to include them as arguments.

One practical distinction is range support. CONCAT can take a range such as A2:C2, which can be convenient when joining a sequence of adjacent cells. The ampersand operator makes each piece explicit, which is helpful when you want to mix cells in a particular order or add text between them. CONCATENATE is also commonly written with individual references and literal text.

Join many values with TEXTJOIN

TEXTJOIN is designed for a list of values that should be separated by a consistent delimiter, such as a comma, space, slash, or line break. Its arguments specify the delimiter, whether empty cells should be ignored, and the text or range to join. This avoids typing a separator between every reference and can make a long formula easier to maintain.

With red in A2, a blank cell in B2, and blue in C2, =TEXTJOIN(", ",TRUE,A2:C2) returns red, blue. The comma and space are the delimiter, and TRUE tells Excel to skip empty cells. If you want the delimiter retained for each position even when a cell is empty, use FALSE instead: with the same layout, =TEXTJOIN(", ",FALSE,A2:C2) returns red, , blue. The second result has two delimiters because the empty middle cell still occupies a position in the joined sequence.

With names in A2:A4, =TEXTJOIN("; ",TRUE,A2:A4) joins the names with a semicolon and a space while ignoring blanks. For example, if A2 is Lee, A3 is blank, and A4 is Patel, the result is Lee; Patel. This is useful for creating compact lists, but consider whether a single long cell is the best destination if the list could grow substantially.

TEXTJOIN is available in modern Excel versions, including Microsoft 365. If a workbook must be opened in an older Excel release that does not support it, the formula may show a name error. For a short list, a formula using & is a widely understood alternative, although it takes more manual separators and will not automatically skip blanks.

Keep dates and numbers readable

When a number or date is joined to text, Excel uses a text representation of the value. That representation may not match the number format you see in the source cell. A date stored as a serial number, for example, can appear as a number in the joined result rather than as a familiar calendar date. Use TEXT to specify the display format as part of the formula.

With an item name in A2 and a price of 12.5 in B2, =A2&" - "&TEXT(B2,"$#,##0.00") returns Pen – $12.50 in an English-language setting using that dollar format. TEXT converts the number to formatted text before concatenation. The dollar sign in this example is a literal format character; adapt the symbol and number format to suit the currency and regional conventions you need.

With a date in A2, ="Order "&TEXT(A2,"mmm d, yyyy") returns a label such as Order Nov 2, 2026 when A2 contains that date. The formula assumes A2 contains a real Excel date value, not text that merely looks like a date. Format codes can produce different styles: for example, a numeric month and day may be preferable in a compact identifier, while a month name can be easier to read in a message.

Formatting inside a concatenation formula changes only the text produced by that formula; it does not change the underlying source value. Keep dates and amounts in their original numeric cells when you need to sort, calculate, or compare them. Use a separate formula cell for a display label, rather than converting the data itself to text.

Choose a method for the job

There is no single best formula for every string. Pick the approach that makes the intent obvious to someone who may maintain the workbook later.

Use & for a short phrase, a custom label, or a few cells with separators placed at specific points.
Use CONCAT when you want to combine a range or a sequence of text arguments without separators.
Use TEXTJOIN when values need the same delimiter and blank cells may need to be skipped.
Keep CONCATENATE when maintaining a workbook that already uses it; there is usually no need to replace working formulas solely because the function is older.

In current Microsoft 365 for Windows, these formulas are entered directly into a worksheet cell and confirmed with Enter. The same basic formula syntax works in Excel for Mac and Excel for the web. Keyboard conventions can differ by operating system, but the formula examples themselves do not require a different Mac or web version. If Excel displays a formula error after copying it from a webpage, check that quotation marks are straight quotes and that the workbook’s regional settings accept commas as argument separators.

Common problems and how to fix them

A missing space is one of the most frequent surprises. Excel does not infer that two names, words, or values need a separator. With a first name in A2 and a last name in B2, =A2&B2 returns MariaChen, not Maria Chen. Insert a quoted space between the references when that is the intended result.

Another common issue is confusing a cell’s displayed formatting with the value used in a formula. If B2 displays 12.50 because it has a number format, a simple join may not preserve the two decimal places in its text. Apply TEXT within the formula when the exact presentation matters. Similarly, use TEXT to control a date’s appearance rather than relying on how the source cell is formatted.

Blank cells are not always errors. The ampersand operator and CONCAT treat an empty cell as an empty piece of text, but fixed separators in the formula remain. A joined list can therefore contain extra spaces or punctuation. TEXTJOIN’s ignore-empty option is useful when blank entries should disappear along with their separators. If a cell contains a formula returning an empty string, it may look blank; TEXTJOIN with TRUE is generally the convenient way to omit such empty text results.

Errors in source cells can also flow into the joined result. If one referenced cell contains an error such as #N/A, a formula combining it may display an error instead of a completed string. Find and correct the source error, or deliberately handle it with an error-handling formula if the workbook’s logic calls for that. Avoid hiding errors without understanding why they occur, because a seemingly polished label can conceal missing or invalid data.

Finally, concatenated output is text. A string such as 00127 may preserve a leading zero when assembled as text, but it is not automatically a number suitable for arithmetic. Conversely, if a formula joins a numeric identifier without first controlling its display, Excel may omit leading zeros that were only supplied by cell formatting. For identifiers, postal codes, and account codes, decide whether the values are text or numbers at the data-entry stage and format the resulting text deliberately.

Frequently Asked Questions

What is the simplest Excel formula to join two cells?
Use the ampersand operator. With text in A2 and B2, =A2&B2 joins them directly; use =A2&" "&B2 if you need a space.

How do I concatenate cells with a comma and a space?
For two values in A2 and B2, use =A2&", "&B2. For a range with many entries, TEXTJOIN can apply the same delimiter between values and optionally skip blanks.

Is CONCATENATE discontinued?
It is an older function that remains supported for compatibility with existing workbooks. For new formulas, & is often the simplest choice, while CONCAT and TEXTJOIN offer useful range and delimiter behavior.

How can I join cells but ignore blanks?
Use TEXTJOIN with TRUE as its ignore-empty argument. For example, with values in A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) joins nonempty cells with spaces and omits empty cells.

Why does my concatenated date show as a number?
Excel stores dates as numeric serial values. Convert the date to the display text you want with TEXT before or during concatenation, using an appropriate format such as mmm d, yyyy.

Can concatenation preserve leading zeros?
Yes, if the identifier is stored as text or you explicitly format its numeric value as text with TEXT. A number format that only displays leading zeros may not carry over when the underlying number is joined into a string.

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.