How to Add Text to a Formula in Microsoft Excel

Updated on:

April 6, 2026

By:

Madhav Bhandari

Use this interactive demo to learn how to add text directly within a formula in Microsoft Excel.

‍

It is very easy to add text to a formula in Microsoft Excel. Here’s a quick guide on how to do it:

‍

Inside your Microsoft Excel worksheet, locate and select the cell that contains the formula you wish to edit.
After that, head over to the ribbon section and click the formula bar.
Place the text selection cursor right after the Equals (=) sign and then start typing the text you wish to add. Enclose it in a pair of quotation marks.
Subsequently, enter an 'Ampersand' symbol between the closing quotation mark and the Sum function. Once done, press the 'Enter' or the 'Return' key to run the formula.
After completing these steps, the text will be added to the selected formula in your Microsoft Excel worksheet.

📌 Why this matters

Adding text to formulas transforms raw calculations into readable reports that make sense to anyone viewing your spreadsheet. Instead of seeing "150" in a cell, you can display "Total Sales: $150" or "Q3 Revenue: $150" directly from the formula itself.

This becomes especially powerful when creating dynamic dashboards or reports that update automatically. Your formulas can generate complete sentences that change based on the data, eliminating the need for separate explanation cells and making your spreadsheets self-documenting for colleagues and stakeholders.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel