'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