Add Text and Formula in the Same Cell in Excel (4 Examples)

Excel is a great tool to analyze and organize data. Sometimes we need to use a lot of formulas in Excel. By default, Excel only shows the formula values in the cell. So, sometimes it may get really hard to understand what is actually going on, only by looking at the formula values. However, adding extra text lines illustrating the formula values can be beneficial for all the report readers. In this regard, you will teach to add text and formulas in the same cell in Excel throughout the article using 4 relevant examples.

Example 1: Add Text and Formula in the Same Cell in Excel

Look at the following picture. An Income-Expense List has 4 columns. We have calculated the monthly savings for each of the persons in the Name column.

Now just from looking at the values, it’s quite uncomfortable to get the idea of what those values are actually about.

To increase the readability, we can add descriptive text with these values. So that any kind of reader can actually understand what those numbers are actually about.

We can merge both the descriptive texts as well as formulas to make those numbers more readable.

To add both the text and formula in the same cell in Excel,

❶ Type the following formula in cell E5 and hit the ENTER button.

To add both the text and formula in the same cell, you have to use the symbol, & and a double inverted comma(“). So, if you want to add texts in between cell values or formulas or functions, just separate them using & and double inverted commas.

For example in the above formula, first, we have inserted cell B5. Then we have inserted the text “‘s monthly savings is: “. To separate this text line from the cell reference and formula, we have used the symbol, &.

❷ To apply the same formula for the rest of the cell, take your mouse cursor to the right-bottom corner of cell E5 and drag the Fill Handle icon up to cell E10. That’s it.

So, after adding the text and formula in the same cell, the final result will look like this:

Add Text and Formula at Any Sequence

You can add the text and formula to any sequence in the same cell. Just make sure you separate the text and formula using the symbol, & and double inverted commas (“).

For example, the following formula will add text first, and then the formula:

If you want to use the formula first and the text appears later, use the following formula:

So, I really hope you can add text and formulas in any sequence in the same cell in Excel.

Example 2: Adding Text and Formula in the Same Cell with TEXT Function

In this example, I will show you how to add text and formula in the same cell with the Text Function in Excel.

So, let’s get started.

Without using text with the formula, the result of the Work Hour column looks like this.

Let’s add more information with the formula result, using the following steps.

❶ First type the following formula in the cell, E5, and hit the ENTER button.

In this formula, we have first inserted a cell, B5. Then we used a text line. To separate the text line from the cell value, B5 we have used the symbol, &, and the double inverted comma (“). Finally, we have used the TEXT function with its arguments.

❷ Drag the Fill Handle icon from cell E5 to E10.

After that, the data table will look like this:

Read More: How to Add Text in IF Formula in Excel

Example 3: Use of Ampersand to Add Text and Formula in the Same Cell

In this section, I’m going to show you how to add the formula with dates in the same cell in Excel.

To do so,

❶ Insert the following formula in the cell, E5.

In the above formula, first I’ve inserted cell B5 and a text. In between them, I used the symbol, & and double inverted commas, (“) to fulfill the syntax requirement. Then the TEXT function comes with its arguments.

After that another text comes which is also separated by the symbol, & and double inverted commas, (“). Then the second TEXT function comes with its corresponding arguments.

❷ Then press the ENTER button.

❸ To apply the above formula in all the cells, drag the Fill Handle icon from cell E5 to cell E10.

That’s all you need to do.

Read More: How to Add Text Before a Formula in Excel

Example 4: Using the CONCATENATE Function to Add Text and Formula in the Same Cell in Excel

You can use the CONCATENATE function to add text and formulas in the same cell in Excel.

To do that, follow the steps below:

❶ First of all type the following formula in the cell, E5.

❷ After that press the ENTER button.

❸ Drag the Fill Handle icon from cell E5 to cell E10 and you’re done with it.

Things to Remember

📌 To separate the text and formula, use the symbol, & and double inverted commas, (“) in between them.

Download Practice Workbook

Conclusion

To sum up, we have discussed adding text and formulas in the same cell in Excel with 4 relevant examples. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries ASAP. And please visit our website Exceldemy to explore more.

Related Articles

• How to Add Text to Cell Value in Excel
• How to Add Text in Excel Spreadsheet
• How to Add Text to Beginning of Cell in Excel
• How to Add Text to Multiple Cells in Excel
• How to Add Text to Cell Without Deleting in Excel
• How to Add Text in the Middle of a Cell in Excel
• How to Add Text to End of Cell in Excel
• How to Add a Word in All Rows in Excel

<< Go Back to Excel Concatenate Text | Concatenate Excel | Learn Excel