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

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

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

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

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

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

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

To get a real date from day number, or "nth day of year" you can use the DATE function.
In the example shown, the formula in C5 is:
=DATE(2015,1,B5)
How this formula works
The DATE function build dates 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 separate text and numbers, you can use a formula based on the FIND function, the MIN function, and the LEN function with the LEFT or RIGHT function, depending on whether you want to extract the text or the number. In...

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 convert dates in text format dd/mm/yy to a true date in mm/dd/yy format, you can use uses a formula based on the DATE function. In the example shown, the formula in C5 is:
=DATE(RIGHT(B5,2)+2000,MID(B5,4,2),LEFT(B5...

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