## 'LEFT function' category

DATEVALUE function not working

The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. However, it must […]

The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. However, it must […]

Extract first word in cell

The formula in cell C3 grabs the first word in B3 using a blank as the delimiting character. =LEFT(B3,SEARCH(" ",B3)-1) […]

The formula in cell C3 grabs the first word in B3 using a blank as the delimiting character. =LEFT(B3,SEARCH(" ",B3)-1) […]

How to use the LEFT function

What is the LEFT function? The LEFT function extracts a specific number of characters always starting from the left. It […]

What is the LEFT function? The LEFT function extracts a specific number of characters always starting from the left. It […]

How to calculate and plot pivots on an Excel chart

If you study a stock chart you will discover that sometimes significant trend reversals happen when a stock chart […]

If you study a stock chart you will discover that sometimes significant trend reversals happen when a stock chart […]

Working with classic ciphers in Excel

What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

Fuzzy lookups

In this post I will describe a basic user defined function with better search functionality than the array formula in […]

In this post I will describe a basic user defined function with better search functionality than the array formula in […]

Lookup and return multiple values concatenated into one cell

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]

Filter duplicate values from a range that begins with string

The array formula in cell B10 extracts duplicate values from cell range B2:D4 if they begin with the condition specified […]

The array formula in cell B10 extracts duplicate values from cell range B2:D4 if they begin with the condition specified […]

Extract unique distinct values from cell range that begins with string

The array formula in cell B10 extracts unique distinct values from cell range B2:D4 that begins with a given condition […]

The array formula in cell B10 extracts unique distinct values from cell range B2:D4 that begins with a given condition […]

Formula for matching a date within a date range

This article demonstrates how to match a specified date to date ranges. The image above shows a formula in cell […]

This article demonstrates how to match a specified date to date ranges. The image above shows a formula in cell […]

5 easy ways to VLOOKUP and return multiple values

This post explains how to lookup a value and return multiple values. No array formula required.

This post explains how to lookup a value and return multiple values. No array formula required.

Sum cells containing numbers and text based on a condition

Question: I want to sum cells that have a "C" and a decimal number. The cells have other numbers and […]

Question: I want to sum cells that have a "C" and a decimal number. The cells have other numbers and […]

How to extract email addresses from an Excel sheet

Question: How to extract email addresses from this sheet? Answer: It dependsÂ on how the emails are populated in your worksheet? […]

Question: How to extract email addresses from this sheet? Answer: It dependsÂ on how the emails are populated in your worksheet? […]

## Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values