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.

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)