You can download an example workbook with all of the TEXT function examples you'll find in this article, plus some extras. You can follow along, or create your own TEXT function format codes.

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM …

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 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 INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The …

Lists all Excel functions by their category, such as Logical functions or Text functions.

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. If the delimiter is an empty text string, this …

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.

The REGEXEXTRACT function allows you to extract text from a string based on a supplied regular expression. You can extract the first match, all matches or capturing groups from the first match.