Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

Insert Line Break in Excel To move to a new line in an Excel cell, simply type text in the cell as normal and then press enter while holding down the alt key.

Cell References in Excel Formulas When you create a formula in an Excel cell, you'll frequently include a reference to another cell in the spreadsheet.

Anatomy of an Excel formula: Using functions to perform calculations Your email has been sent If you’re fairly new to Microsoft Excel, you’ve probably learned to enter data into cells to ...

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.