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

To strip html or other markup from values in cells, you can use the MID function.
In the example shown, the formula in C5 is:
=MID(B5,4,LEN(B5)-7)
How this formula works
The MID function returns characters using a...

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

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 remove the protocol (i.e. http://, ftp://, etc.) and trailing slash from a URL, you can use a formual based on the MID, FIND, and LEN functions. In the example shown, the formula in C5 is:
=MID(B5,FIND("//...

If you need to count how many times a specific a word (or any substring) appears inside a cell, you can use a formula that uses SUBSTITUTE and LEN. In the generic form of the formula above, a1 represents a cell that...

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

If you want to count the total characters in a range of cells, you can do with a formula that uses LEN, along with the SUMPRODUCT function. In the generic form of the formula above, rng represents a range of cells that...

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

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

If you need extract the first name from a full name in Last, First format, you can do so with a formula that uses RIGHT, LEN and FIND functions. In the generic form of the formula (above), name is a full name in this...

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 you need to get the middle name from a full name, and you already have the first and last names in separate cells, you can use a formula that extracts the middle name using the MID and LEN functions, with help from...

To count total lines in a cell, you can use a formula based on the LEN, SUBSTITUTE, and CHAR functions.
In the example, we are using this formula:
=LEN(B5)-LEN(SUBSTITUTE(B5,CHAR(10),""))+1
How the...