In the first formula above, we are using the FIND function to locate the starting position of the number. For the find_text, we are using the array constant {0,1,2,3,4,5,6,7,8,9}, this causes the FIND function to...

At the core, this formula extracts characters from the right with the RIGHT function, using FIND and LEN to figure out how many characters to extract. C4 contains the text "achang@maaker.com", so LEN returns 17...

The DATE function creates a valid date using three arguments: year, month, and day:
=DATE(year,month,day)
In cell C6, we use the LEFT, MID, and RIGHT functions to extract each of these components from a text string...

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

At a high level, this formula uses RIGHT to extract characters from the right side of the name. To figure out the number of characters that need to be extracted to get the first name, the formula uses the FIND function...

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

The first formula uses the FIND function to locate the underscore(_) in the text, then we subtract 1 to move back to the "character before the special character".
FIND("_",B5)-1
In this example , FIND...

At the core, this formula uses the LEFT function to return text starting from the left. To work out how many characters should be returned, the formula uses this expression:
LEN(B5)-(RIGHT(B5)="/")
Here,...

The core of this formula is the MID function, which extracts the text in a URL starting with the character after "//", and ending with the character before the trailing slash ("/"):
=MID(url,start,chars)
The url...

This formula uses the REPLACE function to replace the first character in a cell with an empty string (""). The arguments for REPLACE are configured as follows:
old_text is the original value from column B
start_num...

This formula takes advantage of the fact that TRIM will remove any number of leading spaces. We look for line breaks and "flood" the text with spaces where we find one. Then we come back and grab text from the right....

The core of this formula is the DATE function, which is used to assemble a proper Excel date value. The DATE function requires valid year, month, and day values, so these are parsed out of the original text string as...

If you have worksheet that contains text dimensions (i.e. "50 ft x 200 ft" etc.) you can split the into two parts with formulas that use several text functions.
Background
A common annoyance with data is that it may...

Important: this formula assumes that units are the last 2 characters of the string that includes both a number and a unit of measure.
This formula works because digital units have a "power of 10" relationship.
At the...

First, note that the cells in F5:F13 are formatted as Text prior to entry. This allows the times to contain leading zeros like "083000". Alternately, you can enter these time strings with a single quote at the start...