## 'SUBSTITUTE function' category

Extract n-th word in cell value

The formula displayed above in cell range D3:D9 extracts a word based on its position in a cell value. For […]

The formula displayed above in cell range D3:D9 extracts a word based on its position in a cell value. For […]

How to use the SUBSTITUTE function

Formula in cell E3: =SUBSTITUTE(B3,C3,D3) The SUBSTITUTE function replaces a specific text string in a value. It is case sensitive […]

Formula in cell E3: =SUBSTITUTE(B3,C3,D3) The SUBSTITUTE function replaces a specific text string in a value. It is case sensitive […]

Extract last word in cell

Table of Contents Extract the last word Extract the last letter Extract the last number Get Excel *.xlsx file 1. […]

Table of Contents Extract the last word Extract the last letter Extract the last number Get Excel *.xlsx file 1. […]

Split search value using a delimiter and search for each substring

This article demonstrates formulas and a UDF that searches for values in a table based on concatenated values and returns […]

This article demonstrates formulas and a UDF that searches for values in a table based on concatenated values and returns […]

How to count the number of values separated by a delimiter

This article demonstrates formulas that count values in cell based on a delimiting character. The image above shows a formula […]

This article demonstrates formulas that count values in cell based on a delimiting character. The image above shows a formula […]

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 […]

Substitute multiple text strings

The SUBSTITUTE and REPLACE functions can only handle one string, this article demonstrates two ways to handle more than one […]

The SUBSTITUTE and REPLACE functions can only handle one string, this article demonstrates two ways to handle more than one […]

Count specific multiple text strings in a given cell range

This article demonstrates an array formula that counts how many times multiple text strings exist in a cell range.Â The […]

This article demonstrates an array formula that counts how many times multiple text strings exist in a cell range.Â The […]

Partial match and return multiple adjacent values

This article demonstrates array formulas that search for cell values containing a search string and returns corresponding values on the […]

This article demonstrates array formulas that search for cell values containing a search string and returns corresponding values on the […]

Analyze word frequency in a cell range

This article demonstrates two ways to calculate the number of times each word appears in a given range of cells. […]

This article demonstrates two ways to calculate the number of times each word appears in a given range of cells. […]

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 […]

Text to columns: Split words in a cell

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 […]

Count text string in a range (case sensitive)

Question: How do I count the number of times a text string exists in a column? The text string may […]

Question: How do I count the number of times a text string exists in a column? The text string may […]

Count a specific text string in a cell

Table of Contents Count a specific text string in a cell Count text string in a range (case sensitive) Count […]

Table of Contents Count a specific text string in a cell Count text string in a range (case sensitive) Count […]

Count how many times a string exists in a cell range (case insensitive)

Question: How do I count how many times a word exists in a range of cells? It does not have […]

Question: How do I count how many times a word exists in a range of cells? It does not have […]

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