spot_img

How to add text to formula in Excel

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 FormulaNote: any text written between ” ” will be displayed

Important: Remember to add “&” (ampersand)

 

Template

You can download the Template here – Download
Further reading: 
Basic concepts 
Getting started with Excel
Cell References
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell

RELATED ARTICLESMORE FROM AUTHOR