'MID function' category
Date and Time Functions – A to M
Table of Contents How to use the DATE function How to use the DATEDIF function How to use the DATEVALUE […]
Table of Contents How to use the DATE function How to use the DATEDIF function How to use the DATEVALUE […]
How to decode URL-encoded strings
This formula decodes a URL-encoded string, replacing specific percentage symbol (%) and a hexadecimal number with non-alphanumeric characters. Excel 365 […]
This formula decodes a URL-encoded string, replacing specific percentage symbol (%) and a hexadecimal number with non-alphanumeric characters. Excel 365 […]
How to extract numbers from a cell value
What's on this page How to extract numbers from a cell value - Excel 2016 Sort and return unique distinct […]
What's on this page How to extract numbers from a cell value - Excel 2016 Sort and return unique distinct […]
How to remove numbers from a cell value
This article demonstrates an array formula that extracts all characters except numbers from a cell, cell C3 contains the formula […]
This article demonstrates an array formula that extracts all characters except numbers from a cell, cell C3 contains the formula […]
Extract specific word based on position in cell value
Table of Contents Extract first word in cell value Extract the first word in cell - return warning if not […]
Table of Contents Extract first word in cell value Extract the first word in cell - return warning if not […]
How to use the MID function
The MID function returns a substring from a string based on the starting position and the number of characters you want […]
The MID function returns a substring from a string based on the starting position and the number of characters you want […]
Find last value in a column
This article demonstrates formulas that return the last value in a given cell range or column. The image above shows […]
This article demonstrates formulas that return the last value in a given cell range or column. The image above shows […]
List permutations with repetition and how many to choose from
This article demonstrates a macro that lets you create a list of permutations, repetitions are allowed, based on a number […]
This article demonstrates a macro that lets you create a list of permutations, repetitions are allowed, based on a number […]
List all permutations with a condition
I got a question a while ago about permutations, in essence how to find every permutation between 0 and 9 […]
I got a question a while ago about permutations, in essence how to find every permutation between 0 and 9 […]
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 VLOOKUP
This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.
This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.
A Comprehensive Guide to Splitting Text in Excel
This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]
This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]
How to return a value if lookup value is in a range
In this article, I will demonstrate four different formulas that allow you to lookup a value that is to be found […]
In this article, I will demonstrate four different formulas that allow you to lookup a value that is to be found […]
Search for a text string in a data set and return multiple records
This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]
This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]
Count a specific text string in a cell
Table of Contents Count a specific text string in a cell (case sensitive) Count text string in a range (case […]
Table of Contents Count a specific text string in a cell (case sensitive) Count text string in a range (case […]
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? […]
Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
In this blog post I will demonstrate methods on how to find, select, and deleting blank cells and errors. Why […]
In this blog post I will demonstrate methods on how to find, select, and deleting blank cells and errors. Why […]
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