How to add text to formula?

You may notice some problems when working with data. One of them is creating cells that contain different types of data.

Using an ampersand

Here are the steps to add text to formula in Microsoft Excel.

Suppose I want to add values in Cell A4, B4, C4 and D4 and display the result in cell E4 along with a text message.

I will enter a value in Cell A4, B4, C4 and D4 I will click on cell G4 and then write =A4+B4+C4+D4 & “answer” in the formula bar and press enter.

Add Text to Formula

The result will be displayed as text in the cell where the formula is entered.

Note: any text written between ” ” will be displayed.

Important: Remember to add “&” (ampersand)

Using the TEXT() function

The TEXT() function can be used to format numbers as text. This can be useful when you want to add text to formulas that involve numbers.

The following formula uses the TEXT() function to format the number 1000 as a currency value with two decimal places:

=TEXT(1000, “$#,##0.00”)

This formula will return the string “$1,000.00”.

You can use the TEXT() function to format numbers in a variety of ways.

See also  How to Sort a Pivot Table