The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you …

Instead of entering values, you can refer to data in worksheet cells by including cell references in formulas.

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

Insert a line break to start a new line of text or add space between lines of text in a cell in Excel.

Using references in Excel formulas A reference identifies a cell or a range of cells on a worksheet, and tells Excel where to look for the values or data you want to use in a formula. You can use …

The Picture in cell feature allows you to insert pictures into cells, as well as converting existing floating pictures that are over cells in to a cell. How to insert a picture in to a cell There are …

You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.

This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result. This …

Description Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to …

Check if a cell has any text in it To do this task, use the ISTEXT function. Check if a cell matches specific text Use the IF function to return results for the condition that you specify. Check if …

This argument can be a cell reference, or a fixed value such as "smith" or 21,000. The second argument is the range of cells, C2-:E7, in which to search for the value you want to find. The …