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

Note: any text written between " " will be displayed

Important: Remember to add "&" (ampersand)