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 …

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 …

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, …

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.

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.

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.

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.

Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.