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. But adding extra text lines illustrating the formula values can be beneficial for all the report readers. In this regard, you will teach you to add text and formula in the same cell in Excel throughout the article using 4 relevant examples.


Download the Practice Workbook

You can download the Excel file from the following link and practice along with it.


4 Examples Regarding Add Text and Formula in the Same Cell in Excel

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.

=B5&"'s monthly saving is: "&C5-D5

To add both the text and formula in the same cell, you have to use the symbol, & and 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, &.

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

❷ 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 at 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:

="Robert's monthly saving is: "&C5-D5

Add Text and Formula at Any Sequence

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

=C5-D5 &" is Robert's monthly savings."

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

Read More: Replace Text of a Cell Based on Condition in Excel (5 Easy Methods)


Example 2: Add Text and Formula in the Same Cell in Excel 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.

=B5&"'s total work hour is: "&TEXT(D5-C5,"h")

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.

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

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

After that, the data table will look like this:

Read More: How to Replace Text in Excel Formula (7 Easy Ways)


Similar Readings:


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

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.

=B5&" from "&TEXT(C5,"dd-mmm-yyyy")&" to "&TEXT(D5,"dd-mmm-yyyy")

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.

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

Read More: How to Add Text before a Formula in Excel (4 Simple Ways)


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

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

To do that, follow the steps below:

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

=CONCATENATE("Robert's monthly saving is: ",C5-D5)

❷ After that press the ENTER button.

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

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

Related Content: Excel VBA: How to Find and Replace Text in Word Document


Things to Remember

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


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

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

2 Comments
  1. From your lesson: After that another text comes which is also separated by the symbol, & and double inverted commas, (“).
    REALLY? DOUBLE Inverted COMMAS? How do you get an inverted comma? Kinda looks like a QUOTE to me.
    I’m very much looking forward to an explanation of “double inverted commas”.

    Sincerely,

    Larry Kanzia
    [email protected]

    • Hi Larry Kanzia,
      Inverted commas can be single – ‘x’ – or double – “x”. They are also known as quotation marks, speech marks, or quotes.
      You can get a single inverted comma just by pressing the comma button next to the ENTER button on your keyboard. To insert a double inverted comma, press and hold the SHIFT key, then press the comma key next to the ENTER button.
      Thanks!

Leave a reply

ExcelDemy
Logo