If you want to highlight cells that are blank or empty with conditional formatting, you can do so with a simple formula based on the ISBLANK function. For example, if you want to highlight blank cells in the range B4:...

To strip characters from the left, you can use a formula based on the RIGHT and LEN functions.
In the example shown, the formula in C5 is:
=RIGHT(B5,LEN(B5)-C5)
How this formula works
It may seem counterintuitive...

If you need extract the last name from a full name, you can do so with this rather complex formula that uses several functions. In the generic form of the formula (above), name is a full name, with a space separating...

To extract the top level domain (called "TLD") from a list of domain names or email addresses, you can use a rather complex formula that uses several functions. In the generic form of the formula (above), domain...

If you need to get the nth word in a text string (i.e. a sentence, phrase, or paragraph) you can so with a clever (and intimidating) formula that combines 5 Excel functions: TRIM, MID, SUBSTITUTE, REPT, and LEN.
How...

To split dimensions that like 100x50x25 into three separate parts, you can use some rather complicated formulas that use LEFT, MID, RIGHT, FIND, LEN, and SUBSTITUTE.
Note: you can also use Flash Fill in Excel 2013 and...

To count how many times a specific a word (or any substring) appears inside a range of cells, you can use a formula based on the SUBSTITUTE, LEN, and SUMPRODUCT functions. In the example shown, the formula in C11 is...

To extract lines from a multi-line cell, you can use a clever (and intimidating) formula that combines 5 Excel functions: TRIM, MID, SUBSTITUTE, REPT, and LEN.
In the example shown, the formula in D5 is:
=TRIM(MID(...

To abbreviate text that contains capital letters, using the capital letters, you try this array formula based on the TEXTJOIN function, which is new in Excel 2016. You can use this approach to create initials from names...

If you need extract the last name from a full name in LAST, FIRST format, you can do so with a formula that uses the LEFT and FIND functions. The formula works with names in this format, where a comma and space separate...

If you want to count the total words in a cell, you can do so with a formula that uses the LEN and SUBSTITUTE functions. In the generic form above, a1 represents the address of the cell containing words being counted...

To extract words that begin with a specific character, you can use a formula based on six functions: TRIM, LEFT, SUBSTITUTE, MID, LEN, and REPT. This approach is useful if you need to extract things like a Twitter user...

To count cells that contain more than a certain number of characters you can use a formula based on the SUMPRODUCT, LEN, and N functions. In the example shown, the formula in C2 is:
=SUMPRODUCT(N(LEN(B5:B11)>100...

To count how many times a specific character appears in a cell, you use a formula based on the SUBSTITUTE and LEN functions. In the generic form of the formula above, A1 represents the cell address, and "a" represents...

If you need to count the total characters in a cell, you can do so using the LEN function. In the generic form of the formula above, a1 represents a cell that contains text.
In the example, the formula in the active...