TEXT function - Microsoft Support
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 …
Using IF with AND, OR, and NOT functions in Excel
How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.
MATCH function - Microsoft Support
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.
Text functions (reference) - Microsoft Support
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 …
Include text in formulas - Microsoft Support
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, …
INDIRECT function - Microsoft Support
How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.
TEXTSPLIT function - Microsoft Support
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 …
CONCATENATE function - Microsoft Support
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.
IF function - Microsoft Support
Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false. IF(logical_test, value_if_true, [value_if_false]) For example:
Split text into different columns with the Convert Text to Columns ...
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.