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 format, or you …

Learn how to take the text in one or more cells, and split it out across multiple cells by using Excel functions. This is called parsing, and is the opposite of concatenate. Watch more in this video.

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

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

Use the Text Import Wizard in Excel to import data from a text file into a worksheet. The Text Import Wizard examines the text file that you are importing and helps you ensure that the data is imported in …

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 across columns or …

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

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.

Mar 14, 2012 · Date and time to text The TEXT function in Excel converts a date or time to text in a specified format. The syntax is: =TEXT (value, format_text) Examples: Format today's date: =TEXT …