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

To build email addresses using first and last names, you can use a formula that concatenates values, with help from the LOWER and LEFT functions as needed.
In the example shown, the formula in D5 is:
=LOWER(LEFT(C5)...

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

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

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

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 sum values in columns by matching matching column headers, you can use a formula based on the SUMPRODUCT function. In the example shown, the formula in J5 is:
=SUMPRODUCT(data*(LEFT(headers)=J4))
where "data" is...

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 capitalize the first letter in a word or string, you can use a formula based on the LEFT, MID, and LEN functions. In the example shown, the formula in C5 is:
=UPPER(LEFT(B5))&MID(B5,2,LEN(B5))
How this formula...

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