## 'TEXTSPLIT function' category

Workaround for the TEXTSPLIT function – LAMBDA function

The TEXTSPLIT function works only with single cells. If you try to use a cell range the TEXTSPLIT function returns […]

The TEXTSPLIT function works only with single cells. If you try to use a cell range the TEXTSPLIT function returns […]

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

Extract values between two given delimiting strings

The image above demonstrates a rather small formula in cell D3 that extracts values in cell B3 based on two […]

The image above demonstrates a rather small formula in cell D3 that extracts values in cell B3 based on two […]

How to use the TEXTSPLIT function

The TEXTSPLIT function lets you split a string into an array across columns and rows based on delimiting characters. Formula […]

The TEXTSPLIT function lets you split a string into an array across columns and rows based on delimiting characters. Formula […]

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

If cell contains text from list

This article demonstrates several ways to check if a cell contains any value based on a list. The first example […]

This article demonstrates several ways to check if a cell contains any value based on a list. The first example […]

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

Lookup multiple values in one cell

This article explains how to perform multiple lookups based on values in one cell with a delimiting character using a […]

This article explains how to perform multiple lookups based on values in one cell with a delimiting character using a […]

Sort values in a cell based on a delimiting character

This article demonstrates a macro and a formula that allows you to sort delimited data in a cell or cell […]

This article demonstrates a macro and a formula that allows you to sort delimited data in a cell or cell […]

Rearrange data

Sean asks: Sheet1A B C D 8 Country Europe 9 Lights 100 10 Type A 200 11 12 Country USA […]

Sean asks: Sheet1A B C D 8 Country Europe 9 Lights 100 10 Type A 200 11 12 Country USA […]

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

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

Filter words containing a given string in a cell range

This post describes two ways to extract all matching strings from cells in a given cell range if they contain […]

This post describes two ways to extract all matching strings from cells in a given cell range if they contain […]

Filter unique strings from a cell range

This blog post describes how to create a list of unique words from a cell range. Unique words are all […]

This blog post describes how to create a list of unique words from a cell range. Unique words are all […]

Break up values in a cell range into separate cells based on a space character as a delimiter

This article demonstrates how to convert a range of cells containing strings separated by a delimiter into a range of […]

This article demonstrates how to convert a range of cells containing strings separated by a delimiter into a range of […]

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