Text After an Excel Formula: Add Labels and Sheet Names

To put text after an Excel formula, join the formula result to a quoted text string with an ampersand (&). With values in B2:B6, =SUM(B2:B6)" total" displays a result such as 130 total. If you mean the worksheet tab name itself, Excel can return that name in a cell, but a formula cannot rename the tab.

How to append text to a formula

In Excel for Microsoft 365 on Windows, the ampersand is the simplest way to combine a calculated result with a label. Put the text you want to show inside straight double quotation marks, immediately after the ampersand. The formula still calculates first; Excel then joins its result to the text.

For example, with 18, 22, 25, 30, and 35 in cells B2:B6, the formula =SUM(B2:B6)&" total" returns the text 130 total. The numbers add to 130, and the space before “total” is inside the quotation marks. If you leave that space out, the result is 130total.

Text can go before or between formula results as well. With a product name in A2 and its quantity in B2, you can build a readable message in another cell:

With the product name in A2 and quantity in B2, =A2&": "&B2&" units" could display Notebooks: 12 units.
With a date in A2 and a status in B2, you can join the two values with a separator such as a space, dash, or colon.

Each part is connected with an ampersand. Text that you type directly into the formula needs quotation marks; cell references and formulas do not. The ampersand is often easier to read than CONCAT when you are joining just a few pieces.

Adding spaces, punctuation, and conditional labels

Excel treats spaces and punctuation inside quotation marks as literal characters. This means the formula’s text must include the exact spacing you want in the displayed result. For instance, &" — complete" adds a space, an em dash, and another space before the word “complete.” A hyphen or colon works the same way.

You can also join text to a result produced by an IF formula. With a score in B2, =IF(B2>=70,"Pass","Review")&" - final" displays either “Pass – final” or “Review – final.” The words in the IF formula and the suffix are all text strings, so each needs quotation marks.

When the label depends on the result, put the condition inside IF rather than adding a fixed suffix. For example, a report might show “Over target” for a positive difference and “Below target” for a negative one. This keeps the displayed message meaningful instead of attaching the same words regardless of the calculation.

What happens to numbers and dates

Joining a number to text produces a text value. That is useful for a heading or status message, but the combined result is no longer a numeric value that Excel can directly use in arithmetic. For example, “130 total” looks like a number followed by a label, but Excel treats the whole result as text. Keep the original calculation in a separate cell if later formulas need the number.

Concatenation can also make number formatting appear to disappear. A cell containing the numeric value 130 might be formatted as currency, but joining that value to a text string does not necessarily carry the cell’s displayed currency format into the combined result. Use TEXT when the formula needs to control how a number looks.

With values in B2:B6 that sum to 130, the formula =TEXT(SUM(B2:B6),"$#,##0.00")&" total" returns $130.00 total. The format pattern inside TEXT specifies a dollar sign, thousands separators, and two decimal places. Adjust the pattern to suit the output you need; for example, "0%" displays a decimal as a percentage. TEXT returns text, so the result is still intended for display rather than further numeric calculations.

Dates need similar care. A date is stored as a serial number, and joining it directly to text can show that underlying number instead of a familiar date. Use TEXT with an appropriate date pattern when you want a readable date in a sentence. Keep in mind that a date rendered as text will not behave like a date value for sorting or date arithmetic.

Showing the worksheet tab name in a cell

If by “tab name” you mean the name displayed on the worksheet tab, Excel can retrieve the current sheet name as text. The traditional CELL method needs the workbook to have been saved at least once, because CELL("filename") gets the workbook’s saved path and name as well as the sheet name.

Enter the following in a cell on the worksheet whose name you want to display. This example assumes A1 is a cell on that same sheet; it does not need to contain any particular value:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&" summary"

For a saved workbook with a tab named North, the formula returns North summary. CELL returns a path-like string that includes the workbook name in square brackets followed by the sheet name. FIND locates the closing bracket, and MID extracts the characters after it. The final ampersand adds the literal word “summary.” The formula uses established Excel functions and does not require a newer dynamic-array feature.

If the workbook has not been saved, CELL("filename",A1) can return an empty string, so the extraction will not give the expected tab name. Save the workbook, then recalculate if necessary. When copying the formula to another worksheet, make sure its reference points to a cell on the worksheet whose name you want. This method displays the name in a cell; it does not change the actual tab.

A formula cannot rename the tab

A common mix-up is confusing a worksheet name with text that a formula displays. A formula can read a sheet name and combine it with other text, but Excel does not let a worksheet formula change the tab’s name. To rename a tab manually in Excel for Microsoft 365 on Windows, double-click the sheet tab, type the new name, and press Enter. You can also right-click the tab and choose Rename.

Sheet names have practical limits: they can be no more than 31 characters, cannot be blank, and cannot contain characters such as a colon, backslash, slash, question mark, asterisk, or square brackets. If a tab name is used in a formula as part of a cell reference, a name containing spaces or certain punctuation is usually enclosed in single quotation marks. For example, a reference to cell A1 on a tab named North Region is written as 'North Region'!A1. Those single quotation marks belong to the reference syntax; they are different from the double quotation marks used for literal text in a formula.

On Excel for Mac, the same ampersand approach and CELL formula work. The tab can also be renamed by editing the sheet tab’s name. Excel for the web supports ordinary text concatenation, though some workbook-management details and interface options can differ from the Windows desktop app. In all versions, displaying a name in a cell and renaming a sheet are separate actions.

Choosing between concatenation and number formatting

Use an ampersand when you want a formula to create a sentence, label, or message. Use a custom number format when you want a numeric cell to look as if it has a suffix but still remain numeric. For example, a custom format can show a number as “130 units” while the stored value remains 130 and can still be summed or charted as a number.

To apply a custom format in Excel for Microsoft 365 on Windows, select the numeric cells, open Format Cells with Ctrl+1, choose the Number tab, select Custom, and enter a suitable format such as 0 "units". On Mac, Command+1 opens Format Cells. The word inside the format pattern’s quotation marks is displayed literally; it is not part of the stored number. Custom formatting affects appearance, not the underlying value.

Choose concatenation for a descriptive result such as “Revenue: $1,250” or “130 total.” The result is text.
Choose custom number formatting for a numeric value that needs a visible unit or label but must remain usable in calculations.
Choose TEXT when you need a specific number or date appearance inside a longer text string.
Keep a separate numeric result if you need both a human-readable message and a value for calculations.

Common problems and quick checks

If the formula displays an error or unexpected output, check the exact characters and references before rebuilding it. Excel formulas use an ampersand to join pieces; a plus sign is not a substitute for joining a number to words. Also check that every literal text segment has a matching pair of straight double quotation marks. Curly “smart quotes” copied from a document can cause formula-entry problems.

No space before the label: put the space inside the text, as in &" total".
A date appears as a serial number: use TEXT with a date format rather than joining the raw date value.
The result cannot be summed: the formula has turned the result into text; use the numeric calculation cell or custom formatting instead.
The sheet-name result is blank or odd: save the workbook and confirm the CELL reference is on the sheet you want to identify.
The tab name does not change: a formula only displays text in a cell; rename the tab separately.

Also verify that the cell is not formatted as Text before entering the formula. If it is, Excel may show the formula characters instead of calculating them. Change the cell format to General and enter the formula again. A leading apostrophe before an equals sign also tells Excel to treat the entry as text rather than evaluate it.

Frequently Asked Questions

How do I add words after a SUM formula in Excel?
With the numbers in B2:B6, append an ampersand and a quoted label: =SUM(B2:B6)&" total". Include a leading space inside the quotation marks if you want a gap before the word.

Can I add text after a formula and keep the result numeric?
No. Once a formula joins a number with text, its result is text. If you need the value to remain numeric, apply a custom number format to the cell instead of concatenating a label.

How do I show the current Excel tab name in a cell?
Use CELL("filename") to get the saved workbook information, then extract the text after the closing square bracket. The workbook must be saved, and the formula’s cell reference should be on the sheet you want to identify.

Can an Excel formula change a worksheet tab name?
No. Formulas can display a sheet name as text, but they cannot rename worksheet tabs. Rename a tab through its sheet-tab menu or by editing the tab name directly.

Why does Excel show a number instead of a date after I add text?
Excel stores dates as numbers. When you join a date to text, format the date with TEXT first so it appears in a familiar date pattern. The resulting combined value is text, not a date value.

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.