## 'TEXTSPLIT function' category

Engineering functions – A to C

Table of Contents How to use the BIN2DEC function How to use the BIN2HEX function How to use the BIN2OCT […]

Table of Contents How to use the BIN2DEC function How to use the BIN2HEX function How to use the BIN2OCT […]

Array Manipulation Functions

Table of Contents How to use the CHOOSECOLS function How to use the CHOOSEROWS function How to use the DROP […]

Table of Contents How to use the CHOOSECOLS function How to use the CHOOSEROWS function How to use the DROP […]

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

If cell contains text from list

This article demonstrates several techniques to check if a cell contains text based on a list. The first example shows […]

This article demonstrates several techniques to check if a cell contains text based on a list. The first example shows […]

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

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

Filter strings containing a given substring in a cell range

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

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

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

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