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 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 normalize units to Gigabytes (or megabytes, kilobytes, etc.) you can use a clever formula based the MATCH, LEFT, and RIGHT functions. In the example shown, the formula in C5 is:
=LEFT(B5,LEN(B5)-2)/10^((MATCH(RIGHT...

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

To count numbers in a range that begin with specific numbers, you can use a formula based on the SUMPRODUCT function and LEFT functions.
In the example shown, the formula in E6 is:
=SUMPRODUCT(--(LEFT(B5:B11,2)=...

If you want to get the current workbook's full name and path without a sheet name, you can use a formula that employs several text functions to strip off the sheet name. The final result will be a text string that looks...

To remove a trailing slash from a URL or path, you can use a formula based on the LEFT and LEN functions. In the example shown, the formula in cell C6 is:
=LEFT(B5,LEN(B5)-(RIGHT(B5)="/"))
How this formula...

To remove a file extension from a file name, you can use a formula based on the LEFT and FIND functions. In the example shown, the formula in C5 is:
=LEFT(B5,FIND(".",B5)-1)
How this formula works
The core...

If you want to get the workbook path (directory) only, you can do so with a formula that uses the LEFT and the FIND function. The result will look something like this:
Drive:\path\to\file\ //Windows
Drive:path: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 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...

To remove the last n characters from a text string, you can use a formula based on the LEFT and LEN functions. You can use a formula like this to strip the last 3 characters, last 5 characters of a value, starting on...

To remove specific unwanted characters in Excel, you can use a formula based on the substitute function.
In the example shown, the formula in C4 is:
=SUBSTITUTE(B4,CHAR(202),"")
Which removes a series of 4...

To convert simple text values to numbers, you can use the the VALUE function, or simply add zero as described below.
In the example shown, the formula in C5 is:
=VALUE(B5)
Background
Sometimes Excel ends up with...