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

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

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

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

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 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 lookup data based on multiple complex criteria, you can use the XLOOKUP function with multiple expressions based on boolean logic. In the example shown, the formula in G5 is:
=XLOOKUP(1,(LEFT(B5:B16)="x...

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