Concatenate Text and Formula in Excel: Examples

Formulas & functions · Updated November 22, 2026

To concatenate text and a formula in Excel, join them with the ampersand (&) operator. With the words Ada in A2 and Lovelace in B2, enter =A2&" "&B2 in another cell to return Ada Lovelace; to add a calculated result, use the same pattern around a formula, such as a sum.

How concatenation works in Excel

Concatenation means joining text items into one text string. In Excel, those items can be typed text in quotation marks, values from cells, or results returned by formulas. The ampersand connects each item in the order you write it. It does not add spaces automatically, so include a space as a quoted text item when you need one.

For example, with a first name in A2 and a last name in B2, enter =A2&" "&B2 to put a single space between the names. If A2 contains Maya and B2 contains Chen, the result is Maya Chen. To add a label, put the label in quotation marks and join it to the cell reference.

With a product name in A2 and a quantity in B2, enter ="Item: "&A2&"; quantity: "&B2. If A2 is Notebook and B2 is 4, the result is Item: Notebook; quantity: 4. Text typed directly into a formula must be inside straight double quotation marks. Cell references and formula expressions are not enclosed in quotes.

Join text to a calculation

A formula can be one of the items being joined. Excel calculates that expression and then combines its result with the surrounding text. This is useful for a total, count, percentage, or other value that needs a descriptive label.

Assume B2:B5 contains 200, 300, 250, and 500. Enter ="Total: "&SUM(B2:B5) to return Total: 1250. The sum is 1,250, and the formula converts that result into text as it joins it to the label. If values in B2:B5 change, the displayed total updates because the formula recalculates.

You can also combine text with a calculation involving individual cells. With a unit price in B2 and a quantity in C2, enter ="Line total: "&B2*C2. If B2 is 12 and C2 is 3, the result is Line total: 36. Excel evaluates the multiplication before joining the result to the text. Parentheses can make a more complicated calculation easier to read and help ensure the intended order of operations.

Keep in mind that the combined result is text, even when part of it came from a numerical calculation. It is suitable for a label or message, but not usually for a later calculation as though the entire cell contained a number. Keep the underlying numeric result in a separate cell if other formulas need to use it.

Format numbers, dates, and percentages

When a number is joined directly to text, Excel may show its underlying value rather than the number format you see in the source cell. For example, a date can appear as a serial number, and currency may lose its currency symbol and decimal places. Use the TEXT function when the joined value needs a specific display format.

Assume B2:B5 contains 200, 300, 250, and 500. Enter ="Subtotal: "&TEXT(SUM(B2:B5),"$#,##0.00") to return Subtotal: $1,250.00. The format pattern displays a dollar sign, comma grouping, and two decimal places. The number remains part of a text result, however; the formatting pattern controls how it is displayed within that string.

Assume B2 contains the Excel date January 15, 2026. Enter ="Due: "&TEXT(B2,"mmmm d, yyyy") to return Due: January 15, 2026. The format codes determine the month, day, and year presentation. If the cell contains text that only looks like a date, rather than a date value Excel recognizes, TEXT may not format it as expected.

Assume B2 contains the numeric value 0.125. Enter ="Completion: "&TEXT(B2,"0%") to return Completion: 13%. The percent format displays 0.125 as 13% because it rounds to a whole percent. Use a pattern such as 0.0% if you want one decimal place, which would display 12.5% instead. Choose the pattern to match the precision readers need.

Use CONCAT or TEXTJOIN instead

The ampersand is often the clearest choice for a short expression. Excel also has functions for joining values. CONCAT accepts multiple text items or cell references, while TEXTJOIN adds a delimiter between items and can optionally ignore empty cells. These functions are available in Microsoft 365 and current Excel versions; CONCAT is also supported in Excel 2019 and Excel 2021. The older CONCATENATE function remains available for compatibility, but Microsoft recommends CONCAT for newer workbooks.

Assume A2 contains Maya and B2 contains Chen. Enter =CONCAT(A2," ",B2) to return Maya Chen. This does the same basic joining as the ampersand example. CONCAT can be convenient when you want to pass a sequence of cells or text items as function arguments, though it does not automatically insert separators.

Assume A2:C2 contains a first name, middle name, and last name, with B2 blank. Enter =TEXTJOIN(" ",TRUE,A2:C2) to return the first and last names separated by one space, without an extra space for the blank middle-name cell. The first argument is the delimiter, and TRUE tells Excel to ignore empty cells. If blank cells should still occupy a position, use FALSE instead.

  • Choose the ampersand for short formulas where the joining order should be immediately visible.
  • Choose CONCAT to pass several text items or ranges without repeatedly typing the ampersand.
  • Choose TEXTJOIN when you need a repeated separator, such as a comma, space, or line break, and may want empty cells skipped.

Build reusable labels and messages

Concatenation is useful for creating readable summaries from data without changing the original values. For example, a report can combine a customer name and an order number, or a dashboard can attach a label to a live calculation. Using cell references means the output changes when its source data changes, which can save manual rewriting.

Assume A2 contains order number 1048 and B2 contains the customer name Jordan Lee. Enter ="Order "&A2&" for "&B2 to return Order 1048 for Jordan Lee. If order numbers need leading zeroes, format them as text in the output rather than relying on the source cell’s display format.

Assume A2 contains the numeric order number 48. Enter ="Order "&TEXT(A2,"00000") to return Order 00048. The zeroes in the TEXT pattern act as required digit positions. This is useful for codes with a fixed width, but remember that the joined result is text, not a number suitable for arithmetic.

For a multi-line message, a line break can be inserted with CHAR(10). Assume A2 contains the customer name and B2 contains the total as a numeric value. Enter ="Customer: "&A2&CHAR(10)&"Amount: "&TEXT(B2,"$#,##0.00"). If A2 is Jordan Lee and B2 is 125, the result has Customer: Jordan Lee on the first line and Amount: $125.00 on the next. Turn on Home > Wrap Text for the result cell so the line break is visible within the cell. Row height may also need adjustment.

Common errors and how to fix them

A formula that appears as plain text instead of a result is often stored in a cell formatted as Text, or Excel may be set to display formulas. Change a Text-formatted cell to General using Home > Number Format, then re-enter the formula so Excel evaluates it. To toggle formula display on Windows, press Ctrl+` (the key usually shares a position with the tilde); on Mac, use Control+`. The shortcut can vary with keyboard layout.

Missing spaces or punctuation are another frequent issue. Excel joins exactly what the formula specifies; it does not infer where words should be separated. Add a quoted space, comma, colon, or other delimiter at the correct position. When using CONCAT, supply the delimiter as its own item. When using TEXTJOIN, set the delimiter as the first argument.

If dates or amounts look wrong, apply TEXT to the value before joining it. Do not add quotation marks around a cell reference or a calculation: Excel would treat the characters as literal text rather than evaluate the reference or expression. Also check for errors in source cells, because an error such as #VALUE! can flow into the final joined result.

Finally, check whether the formula returns the expected kind of value. Joining a number to a label produces text. If a later calculation must use the number, point that calculation at the original numeric cell or store the number separately instead of trying to extract it from the sentence.

Frequently Asked Questions

Can I concatenate text and a SUM formula in Excel?
Yes. Put the label in quotation marks, join it with the ampersand, and include SUM as the calculation. For example, with values in B2:B5, use ="Total: "&SUM(B2:B5). The result is a text label followed by the calculated sum.

How do I add a space between concatenated cells?
Include a space inside quotation marks between the references. With a first name in A2 and last name in B2, use =A2&" "&B2. The quoted space is an explicit item in the formula.

Why does my concatenated date show as a number?
Excel stores dates as numeric values, and joining one directly to text can expose that underlying value. Wrap the date reference in TEXT with the display pattern you want, such as =TEXT(A2,"mmmm d, yyyy") before joining it to a label.

Can I concatenate cells and keep the result numeric?
No. A result that combines text and a number is text. Keep the numeric calculation in a separate cell if it needs to be used in further arithmetic, and create a separate concatenated cell for display.

What is the difference between CONCAT and TEXTJOIN?
CONCAT joins the items you provide but does not add a delimiter automatically. TEXTJOIN inserts a chosen delimiter between items and can ignore empty cells. For a short expression, the ampersand operator is often simpler than either function.

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.