To combine text with a cell value in Excel, join them with the ampersand operator (&). For example, if A2 contains 104, the formula ="Order number: "&A2 displays Order number: 104. Use TEXT when you need a number, date, or percentage to keep a particular display format in the combined result.
How the ampersand combines text and values
The ampersand joins pieces in the order you write them. Each piece can be quoted text, a cell reference, or another expression. Excel returns one text string, so the formula changes the displayed result without changing the original value stored in the referenced cell.
With a customer name in A2 and an order number in B2, a formula can create a sentence or label from both cells. Assume A2 contains Maya Chen and B2 contains 104; the formula ="Order "&B2&" for "&A2 returns Order 104 for Maya Chen. The quoted spaces are important: Excel does not automatically add spaces between joined pieces.
You can use the same technique to add punctuation, units, or explanatory words. A cell containing the number 7 can appear as “7 days” when joined to the quoted text “ days.” However, the combined result is text, not a numeric 7 with a unit attached. Keep the original numeric cell if you need to calculate with it later.
Useful formulas for common tasks
For a short label, put the fixed wording in quotation marks and refer to the cell containing the value. With a product name in A2 and a quantity in B2, the formula =A2&" — quantity: "&B2 might return Notebook — quantity: 3. This approach is easy to read and works well when joining a few pieces.
For a currency label, TEXT can control how the amount appears. With an item name in A2 and a price of 27.5 in B2, the formula =A2&" costs "&TEXT(B2,"$#,##0.00") returns Notebook costs $27.50. The format pattern requests a dollar sign, a thousands separator when needed, and two decimal places.
For dates, use TEXT to specify the date display in the sentence. With a valid Excel date in C2 representing July 4, 2026, the formula ="Due: "&TEXT(C2,"mmmm d, yyyy") returns Due: July 4, 2026. The format string uses four m characters for the full month name, d for the day, and yyyy for a four-digit year.
To combine several cells with a separator, CONCAT or TEXTJOIN can be more convenient than typing many ampersands. With first, middle, and last names in A2:C2, the formula =CONCAT(A2," ",B2," ",C2) joins them with spaces. With words in A2:C2, the formula =TEXTJOIN(" ",TRUE,A2:C2) uses a space between entries and ignores empty cells because its second argument is TRUE. CONCAT does not add separators for you; TEXTJOIN does.
Why numbers and dates can look different
Excel stores numbers and dates as underlying values and applies number formats to control how they look in cells. Concatenation uses the underlying value converted to text, not necessarily the exact appearance you see in the source cell. A date formatted as July 4, 2026 in a worksheet may appear as a serial number in a joined sentence; a currency amount may lose its currency symbol or decimal places.
That is why TEXT matters when the appearance is part of the message. Its first argument is the value to convert, and its second is a number-format code in quotation marks. Common patterns include "0.00" for two decimal places, "0%" for a whole percentage, and "mmm d, yyyy" for an abbreviated month, day, and year. The format controls the text output; it does not change the value in the original cell.
For example, assume B2 contains the decimal value 0.125. The formula ="Completion: "&TEXT(B2,"0.0%") returns Completion: 12.5%. If you instead join B2 directly, Excel may show 0.125 rather than 12.5%. Choose a format that suits the reader and the precision you need; percentage formats can round the displayed result.
Currency format codes can depend on the currency and regional conventions relevant to your workbook. A dollar sign in a format string is not a guarantee that the amount is actually denominated in U.S. dollars. Label the currency accurately, and avoid using a display format to imply a currency that the source data does not represent.
Choosing between ampersand, CONCAT, and TEXTJOIN
For a few pieces of text, the ampersand is usually the clearest choice. It is short, available in Excel, and makes the joining order explicit. CONCAT is useful when you prefer to supply multiple arguments to one function, especially when the pieces are already in a range. Neither ampersand nor CONCAT inserts a delimiter automatically.
Choose TEXTJOIN when you need a repeated separator, such as a comma, space, or line break, across a range. Its ignore-empty option is helpful for optional fields: a missing middle name, for example, need not create an extra blank between the first and last names. Check the source cells, though. A cell containing a formula that returns an empty string may be treated differently from a truly empty cell in some formula designs, so verify the result when blank handling matters.
Use TEXT alongside any joining method when a number or date must have a controlled display. It is not a separate replacement for joining: it formats a value into text, which you can then combine with a label. For a simple whole-number count, direct joining may be fine; for prices, percentages, and dates, explicit formatting is generally more dependable.
Spacing, punctuation, and blank cells
Excel includes exactly the characters you provide. If you write text immediately before and after a cell reference without putting a space in either quoted text segment, the result will run together. Decide whether spaces belong at the end of one text fragment or at the beginning of the next, and use the same convention throughout a long formula.
For optional content, an IF formula can keep a label from appearing when its value is missing. With a description in A2 and an optional reference in B2, the formula =IF(B2="","",A2&" — "&B2) returns an empty string when B2 is blank, or joins the description and reference otherwise. This is useful for reports, but it can hide missing data if a blank reference should instead be investigated.
For lists, TEXTJOIN is often easier than writing a separate IF test for every entry. You can also clean source text before joining if it contains unwanted spaces. Be cautious about removing spaces indiscriminately: spaces may be meaningful in names, addresses, or product descriptions. Fix the source data only when you understand what those characters represent.
Common problems and how to fix them
- The date appears as a number: wrap the date reference in TEXT and choose a date pattern such as
"mmm d, yyyy". - The amount loses decimals or a currency symbol: format the amount with TEXT and a suitable pattern, then check that the currency label is truthful.
- Words run together: add a literal space inside the quoted text where the separation belongs.
- The formula displays instead of calculating: check that the cell is not formatted as Text, that the entry begins with an equals sign, and that Show Formulas is not turned on. If the cell is Text-formatted, change its format to General and re-enter the formula.
- The result shows an error: inspect each referenced cell and check that parentheses, quotation marks, and argument separators are balanced. In Excel formulas, text literals need straight double quotation marks.
- A result looks cut off: the cell may be too narrow to display the complete string. Widen the column or use Wrap Text; the full value may still be present even when it is not all visible in the grid.
Another common misconception is that adding text to a number leaves the result available for arithmetic. Once a formula joins the number to text, the result is text. For totals, sorting, charting, and numeric comparisons, retain a separate numeric column and create a combined label only where a human-readable display is needed.
Where to enter and edit the formula
In Excel for Microsoft 365 on Windows, select the cell where the combined text should appear, type the formula in the formula bar or directly in the cell, and press Enter. Use the fill handle to copy a relative-reference formula down a column; references such as A2 and B2 normally adjust to A3 and B3 in the next row. If a reference must remain fixed while copying, use dollar signs in the reference, such as $A$2.
On Mac, the formulas work the same way, and you can enter them in a cell or the formula bar. Excel for the web also supports these common formulas, though the ribbon layout and some editing details can differ from the desktop app. If your Excel installation uses a regional list separator other than a comma, formulas with function arguments may require the separator used by that installation; the ampersand operator itself is unchanged.
For a reusable report, keep raw values in dedicated columns and put the display formula in another column. That separation makes it easier to update the source data, apply numeric calculations, and change wording without damaging the underlying information. If the combined text is needed only once, copying the result and using Paste Special > Values can replace formulas with their current displayed text; retain a copy of the formula or source data if future updates are likely.
Frequently Asked Questions
How do I add text before a cell value in Excel?
Enter text in double quotation marks, add the ampersand operator, and reference the cell. For example, with a value in A2, ="Total: "&A2 places Total: before that value.
How do I add a space between text and a cell value?
Include a space inside the quoted text. For example, ="Item "&A2 has a space after Item. Excel does not insert spacing automatically.
How can I combine text with a date without showing a serial number?
Use TEXT around the date reference and choose the display pattern you want, such as a month name and four-digit year. The original date remains unchanged in its source cell.
Can I combine text and a cell value without a formula?
You can type a fixed sentence directly into a cell, but it will not update when the source value changes. A formula is the better option for a label that should stay linked to changing data.
Can I calculate with the combined result?
Not as if it were still the original number: joining creates text. Keep the numeric value in its own cell for calculations, and use a separate combined-text cell for presentation.
Related
- Protect Sheet in Excel: Allow Editing Specific Cells
- Excel Conditional Formatting Icon Sets Explained
- Markdown Table Merge Cells? What You Can Do
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- AVERAGEIF Excel Range: Syntax, Examples, and Common FixesIn Excel, the range in AVERAGEIF is the group of cells Excel checks against your condition; the optional…
- Excel Text Functions List: Names, Uses, and ExamplesExcel’s text functions help you extract, combine, clean, compare, format, and convert text or values. The main functions…
- Excel Conditional Formatting If: How Rules WorkIn Excel, conditional formatting applies a format when a cell or formula meets a condition—in effect, an “if…
- Excel Timesheet Calculator Formula: Examples and TipsFor an Excel timesheet with start time in B2, end time in C2, and an unpaid break duration…
- Excel INDIRECT: Reference Another Workbook or FileYes. Excel’s INDIRECT function can refer to a cell in another workbook, but the source workbook must be…
- Excel Formula for Date Range: Count Dates and MatchFor dates in A2:A100 and a start date in D2 and end date in E2, count dates in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.