How to add text in Excel formula

We are used to doing calculations in Microsoft Excel. But sometimes, in the result column text is needed to represent the data clearly. It helps us to visualize the report to everyone. Maybe you need to add text in front of the formula and sometimes after the formula, right? Are you wondering how to add text to the Excel formula? It is not that critical. There are a few ways to perform the task. Today I will guide you on how to add text to an Excel formula.

After reading this content you will be able to perform the following activities.

• Adding text after/before any formula.
• Adding text after/before any number in a formula.
• Adding text after/before any currency in a formula.
• Adding text after/before any time in a formula.
• Adding text after/before any dates in a formula.
• Adding space between text in the Excel formula

How to add text in Excel formula

To add text in the Excel formula depends upon the type of data of the result cell. The resulting cell can be a text, numbers, currencies, time, date, etc. I will share how to add text with all formats of data.

To add text with text

Sometimes in Excel, we may need to add text with text. An example screenshot is shown here for your clear understanding.

The text of two different cells is combined with the help of ampersand (&). If you notice the formula bar, you will understand the formula, I will give the explanation for you.

Explanation of the formula

Here, First Name= B4, Last Name= C4, and Role= D4. To combine all three I have used ampersand (&). Why I have used double quotation marks (“”)? double quotation marks (“”) are used to add space between two cell data.

To add text with numbers

Again I have used ampersand (&) to add text with numbers. If you notice clearly you will see I have added space and text inside the double quotation marks (“”).

Explanation of the formula

Here in the Performances column, I have added two columns number and a text. Run=D4, Wickets=E4, I have used ampersand (&) to combine two columns and double quotation marks (“”) to add space and text.

To add text with currency

Here also I have used ampersand (&) to add text with currency. If you notice clearly you will see I have added space and text inside the double quotation marks (“”). Besides these, I have used the TEXT function and  ###,### for thousand separators to display the data.

Explanation of the formula

Here, Monthly salary=D4, One year = 12 months. multiply D4 and 12. used (###,###) for thousand separator.

To add text with the time

Here also I have used ampersand (&) to add text with the time. If you notice clearly you will see I have added space and text inside the double quotation marks (“”). Besides these, I have used HH:MM:SS  to keep the time format in hours, minutes, and second. TEXT function is used to change the way of displaying any numerical data is.

Explanation of the formula

To calculate Practice time I have just deducted entry time from exit time. Other cases, I have already discussed above.

To add text with the date

For this example also I have used the ampersand (&) to add text with the date. If you notice clearly you will see I have added space and text inside the double quotation marks (“”). Besides these, I have used the TEXT function and  YYYY:MM:DD  to keep the date format in Year, month, and days.

Explanation of the formula

Here the start of the contract is C4, End of the contract is D4. To calculate the total duration I have deducted C4 from D4 and written the last day of service.

For all the above examples, I have used the ampersand (&) sign to combine two texts. But Microsoft Excel offers more functions to do the same task. Do you want to learn all of them?

Instead of I have used the ampersand (&) sign you can use CONCAT, CONCATENATE, and TEXTJOIN functions. SYNTAX of these functions are given here for your reference.

If you want to learn more about combining two or more cells together you can read the below content.

How to add two text cells together in excel

Why adding text in Excel formula is important

When we are preparing a report database in Microsoft Excel, if you add only numbers people will not understand clearly. It is not visualized also. Sometimes we need to add units for better understanding.

 What people generally do is add one more column to add text which is not fair actually, looks odd as well. That is why adding text with different types of numerical data is important.

Displaying the numerical data in a specific format is also important. Otherwise, nobody will understand the value only.  We have used the TEXT function to do that.

Dear learner, I hope, this content on how to add text in Excel formula is very much helpful to you. If you have any questions to understand please comment here. Your comments always carry value to us. I will try to reply to your question as soon as possible. Thank You.