If you’ve already entered data and Excel has removed your leading 0's, you can use the TEXT function to add them back. You can reference the top cell with the values and use …

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

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

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.

TEXTJOIN function. Combines the text from multiple ranges and/or strings. TEXTSPLIT function. Splits text strings by using column and row delimiters. TRIM function. Removes spaces from …

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

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.

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 …

Mar 14, 2012 · 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(TODAY(), …

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.