Excel Formulas With Text: How to Combine Words and Values

Formulas & functions · Updated November 18, 2026

To use text in an Excel formula, put literal words inside straight double quotation marks, such as ="Ready". To combine text with a cell value, join the parts with the ampersand operator, for example ="Order: "&A2; the formula returns the words “Order: ” followed by the value in A2.

How text works inside an Excel formula

Excel treats text in a formula differently from a cell reference or a number. Text you type directly into a formula must be enclosed in double quotation marks. Without those marks, Excel generally interprets a word as a defined name or another identifier, and may return a name error if it cannot resolve it.

For example, with no cell layout required, the formula ="Hello" returns the text Hello. By contrast, =A2 returns whatever is stored in cell A2. If A2 contains the word North, Excel displays North, but the formula refers to the cell rather than containing the word itself. This distinction matters when the referenced cell changes: the formula result changes with it.

Text can be combined with numbers, dates, and other text. The ampersand operator joins pieces from left to right. Put a space inside quotation marks when you want a visible gap between two pieces; otherwise, Excel joins them without adding punctuation or spacing. The result of a joining formula is text, even when one of its pieces is a number.

Join words, cells, and values

Suppose A2 contains a first name and B2 contains a surname. With those names in A2 and B2, this formula inserts one space between them:

=A2&" "&B2

If A2 contains Maya and B2 contains Chen, the result is Maya Chen. Change the separator to a comma and a space, a slash, or a label by changing the text inside quotation marks. For example, the formula can create a customer label, a tracking phrase, or a sentence from values in different columns.

For a fixed label followed by a cell value, with an order number in A2, use ="Order: "&A2. If A2 contains 5084, the returned text is Order: 5084. Any spaces or punctuation you need should be included in the quoted part of the formula.

Excel also has functions for joining text. With first names in A2 and surnames in B2, =CONCAT(A2," ",B2) returns the same result as the ampersand example. CONCAT is useful when combining several items, but it does not automatically insert spaces or other separators: include them as separate arguments.

When combining a range and adding a consistent delimiter, TEXTJOIN can be more convenient. With names in A2:A5, =TEXTJOIN(", ",TRUE,A2:A5) joins the nonempty cells using a comma and a space. The TRUE argument tells Excel to ignore empty cells; use FALSE if empty cells should be included in the join. CONCAT and TEXTJOIN are available in current Microsoft 365 Excel.

Keep numbers, dates, and percentages readable

A common surprise is that joining a number to text does not necessarily preserve the number’s displayed format. Excel stores dates as serial numbers and may store currency as ordinary numeric values with a display format applied. When a formula combines such a value with text, use TEXT to specify how the value should appear in the returned string.

With a date in A2, ="Due: "&TEXT(A2,"mmm d, yyyy") produces a label such as Due: Nov 2, 2026, depending on the value in A2. The format code controls the appearance: for example, d displays the day, mmm displays an abbreviated month, and yyyy displays a four-digit year. If the date itself is wrong, changing the format code will not correct its underlying value.

With a price in B2, ="Price: "&TEXT(B2,"$#,##0.00") displays a currency-style value with two decimal places. With a completion rate in C2, =TEXT(C2,"0.0%")&" complete" displays a percentage to one decimal place followed by the word complete. In the latter example, if C2 contains 0.735, the result is 73.5% complete.

The format code in TEXT is a pattern, not a cell-format setting. It changes the appearance of the value inside the formula’s text result, but that result is text and cannot be used directly as a numeric value in later arithmetic without converting it back.

Use text in conditions and criteria

Text is also used to tell logical and counting functions what to look for. With a status in C2, =IF(C2="","Missing","Ready") returns Missing if C2 is blank and Ready otherwise. The comparison to an empty string checks whether the cell has no displayed content; a formula in C2 that returns an empty string will also satisfy this test.

For a simple status check, with payment labels in A2:A20, =COUNTIF(A2:A20,"Paid") counts cells whose content matches Paid. Text criteria in functions such as COUNTIF are quoted because they are literal text. Criteria can also include comparison operators. For example, with A2:A20 containing labels, =COUNTIF(A2:A20,"Paid*") counts text beginning with Paid; the asterisk is a wildcard for any number of characters.

When a criterion combines an operator with a value from a cell, join those parts. With amounts in B2:B20 and a threshold in D2, =COUNTIF(B2:B20,">"&D2) counts amounts greater than the value in D2. The operator is quoted text, while D2 is a reference. This pattern is useful in criteria-based functions, but the exact criteria rules differ by function, so consult the function’s syntax when using more complex tests.

Quotation marks, apostrophes, and special characters

Double quotation marks mark the beginning and end of a text string in a formula. If the text itself needs to include a double quotation mark, double it inside the formula. With no cell references required, ="He said ""Hello""" returns He said “Hello” with quotation marks around Hello. This is a frequent source of formula errors because a single unpaired quote can make Excel treat the rest of the formula as part of the text.

An apostrophe is different from a double quotation mark. In a formula’s text string, an apostrophe can be typed normally. For instance, with a name in A2, ="'"&A2 adds an apostrophe before the value in A2. Apostrophes also have a separate role when typed before an entry in a worksheet: a leading apostrophe can force an entry such as a code with leading zeros to be treated as text, and the apostrophe itself is not displayed in the cell.

To include a line break in a joined result, use CHAR(10). With a city in A2 and a country in B2, =A2&CHAR(10)&B2 joins them with a line break. Turn on Wrap Text using Home > Wrap Text to display the two lines in the cell. The formula creates the line-break character, while Wrap Text affects how the cell displays it.

Fix formulas that display text instead of a result

If Excel shows the formula itself, such as ="Ready", rather than Ready, the cell may be formatted as Text or Excel may be displaying formulas in the worksheet. First check Home > Number Format and set the cell to General. Then edit the cell and confirm the formula again; changing the format alone may not make an already-entered formula recalculate.

If many cells show formulas instead of results, check whether Show Formulas is enabled on the Formulas tab. Turning it off returns the worksheet to its normal result display. A formula may also be preceded by an apostrophe, which causes Excel to treat the entry as text rather than calculate it. Remove the leading apostrophe if the cell is meant to contain a working formula.

If Excel reports a problem with the formula, check for missing quotation marks, parentheses, or ampersands. Each text section needs a matching pair of quotation marks, and each piece being joined needs an operator or function argument between it and the next piece. Also check whether you typed straight quotation marks rather than typographic “curly” quotation marks copied from another application.

Another issue is joining an empty cell. The result may contain an extra space or delimiter because the formula adds that separator regardless of whether a neighboring cell has content. TEXTJOIN can ignore empty cells in a range, while an ampersand formula may need an IF condition or a different layout to avoid unwanted separators. Inspect the source cells as well: a cell that looks blank may contain spaces or a formula returning an empty string.

Choose the right way to combine text

For a short formula with a few pieces, the ampersand is easy to read and works in older Excel versions as well as current ones. CONCAT is a function-based option for combining several arguments. TEXTJOIN is usually the clearest choice when you need one delimiter between many cells and want to skip blanks. None of these methods automatically knows whether a separator should be a space, comma, or dash; specify that choice in the formula.

  • Use the ampersand for a compact label or a few cell references.
  • Use CONCAT when a function form is convenient and you are joining several selected items.
  • Use TEXTJOIN when joining a range with a repeated separator or when empty cells should be ignored.
  • Use TEXT around a number or date when the text result needs a deliberate display format.

Compatibility can matter when a workbook is shared. The ampersand is the most broadly compatible approach. CONCAT and TEXTJOIN are supported in modern Excel releases, including Microsoft 365; if a workbook will be opened in a much older version, check compatibility in that version or use a simpler ampersand formula. In Excel for the web, these formula approaches are also available, though ribbon placement and some interface details can differ from Excel for Windows.

Frequently Asked Questions

Can I put words directly in an Excel formula?
Yes. Put literal words inside straight double quotation marks. For example, ="In stock" returns In stock. If the words are not quoted, Excel may interpret them as names rather than text.

How do I add a space between text from two cells?
With the two pieces of text in A2 and B2, use =A2&" "&B2. The quoted space is the separator. Without it, the values are joined directly.

How do I combine text with a date without getting a number?
With the date in A2, use ="Date: "&TEXT(A2,"mmmm d, yyyy"). TEXT formats the date for the combined text, so the result shows a readable month, day, and year rather than a date serial number.

Why does my formula appear in the cell instead of its answer?
The cell may be formatted as Text, the formula may have a leading apostrophe, or Show Formulas may be on. Set the cell to General, edit and confirm the formula again, and check the Formulas tab’s Show Formulas setting.

Can a formula return both words and a number?
Yes, but the combined result is text. With a count in B2, ="Items: "&B2 returns a label followed by the count. If you need commas or decimal places, format the numeric part with TEXT before joining it.

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.