If you need to extract the first word from some text you can use a formula that uses the FIND and LEFT functions. From the example, the formula looks like this:
=LEFT(B4,FIND(" ",B4)-1)
How this formula...

To match the first value that does not begin with a specific string, you can use an array based on the MATCH and LEFT functions. In the example shown, the formula in F5 is:
{=MATCH(TRUE,IF(LEFT(code,1)<>"N...

If want to extract the name part of an email address, you can do so with a formula that uses the LEFT and FIND functions. In the generic form above, email represents the email address you are working with.
In the...

To remove the first character in a cell, you can use the REPLACE function. In the example shown, the formula in D5 is:
=REPLACE(A1,1,1,"")
How this formula works
This formula uses the REPLACE function to...

When date information from other systems is pasted or imported to Excel, it may not be recognized as a proper date or time. Instead, Excel may interpret this information as a text or string value only.
To convert a...

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 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 want to extract the domain name from a complete URL, you can do so with a formula that uses the the LEFT and FIND functions. In the generic form above, url is the the URL you are working with.
In the example, we...

To convert a measurement in feet and inches to inches only (i.e. 4'5" to 53) you can use a formula based on several functions, including LEFT, FIND, MID, and SUBSTITUTE. In the example shown, the formula in D5 is:
=...

To convert text in an unrecognized date format to a proper Excel date, you can parse the text and assemble a proper date with a formula based on several functions: DATE, LEFT, MID, and RIGHT. In the example shown, the...

To build an email address from a first and last name, you can use a formula based on simple concatenation with help from the LEFT and LOWER functions.
In the example shown, the formula in D5 is:
=LOWER(LEFT(B5)&...

Note: these is an experimental formula that uses a hard coded array constant, set down here for reference and comment. Casually tested only, so take care if you use or adapt.
Sometimes you encounter data that mixes...

To allow only values that begin with certain text, you can use data validation with a custom formula based on the EXACT and LEFT functions.
In the example shown, the data validation applied to C5:C9 is:
=EXACT(LEFT(...

If you need extract the first name from a full name, you can easily do so with the FIND and LEFT functions. In the generic form of the formula (above), name is a full name, with a space separating the first name from...

To split a text string at a certain character, you can use a combination of the LEFT, RIGHT, LEN, and FIND functions.
In the example shown, the formula in C5 is:
=LEFT(B5,FIND("_",B5)-1)
And the formula in...