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.

Adding text and formula

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)