The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable …

To include text in your functions and formulas, surround the text with double quotes (""). The quotes tell Excel it's dealing with text, and by text, we mean any character, including numbers, …

The FORMULATEXT function returns what is displayed in the formula bar if you select the referenced cell. The Reference argument can be to another worksheet or workbook.

How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined.

Release notes Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split …

Copy the example data in each of the following tables and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.