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(...

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:...

If you need 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),...

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 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...

Note: Excel contains many built-in rules for highlighting values with conditional formatting, including a rule to highlight cells that end with specific text. However, if you want more flexibility, you can use your own...

If want to extract the domain from an email address, you can do so with a formula that uses the RIGHT, LEN, and FIND functions. In the generic form above, email represents the email address you are working with.
In the...

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...

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 txt represents...