'TEXTJOIN function' category
Table of Contents How to use the BIN2DEC function How to use the BIN2HEX function How to use the BIN2OCT […]
This formula decodes a URL-encoded string, replacing specific percentage symbol (%) and a hexadecimal number with non-alphanumeric characters. Excel 365 […]
This article demonstrates formulas that rearrange values in a cell range to a single column. Table of Contents Rearrange cells […]
What's on this page How to extract numbers from a cell value - Excel 2016 Sort and return unique distinct […]
This article demonstrates an array formula that extracts all characters except numbers from a cell, cell C3 contains the formula […]
This article demonstrates several techniques to check if a cell contains text based on a list. The first example shows […]
This article demonstrates Excel formulas that extract unique distinct values from a cell range and concatenates the values using any […]
This article demonstrates formulas and a UDF that searches for values in a table based on concatenated values and returns […]
The TEXTJOIN function is a relatively new function introduced in Excel 2019, it is like the CONCATENATE function on steroids […]
What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]
This article demonstrates a formula that points out row numbers of records that overlap the current record based on a […]
This article explains how to perform multiple lookups based on values in one cell with a delimiting character using a […]
I will in this article demonstrate how to use the VLOOKUP function with multiple conditions. The function was not built […]
This article demonstrates how to sort records in a data set based on their count meaning the formula counts each […]
Sean asks: Sheet1A B C D 8 Country Europe 9 Lights 100 10 Type A 200 11 12 Country USA […]
EEK asks: I am looking for the same formula on this page, but targeting a range of MxN (spanning multiple […]
VLOOKUP a multi-column range and return multiple values.
This article shows how to extract unique distinct values based on a condition applied to an adjacent column using formulas. […]
This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]
Joining multiple cell values in Excel is not easy, for example, the CONCATENATE function allows you to only reference a […]
This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]
This blog post describes how to create a list of unique words from a cell range. Unique words are all […]
In this post I am going to add one more function to the weekly schedule I built in a previous […]
Unique values are values occurring only once in cell range. This is what I am going to demonstrate in this blog […]
What's on this page Unique distinct values sorted based on frequency (single column) Unique distinct values sorted based on frequency […]
The image above shows an array formula in cell B12 that extracts values shared by cell range B2:D4 (One) and […]
Table of Contents Filter values occurring in range 1 but not in range 2 Filter not shared values out of […]
This article describes two formulas that extract duplicates from a multi-column cell range, the first one is built for Excel […]
Table of Contents How to perform a two-dimensional lookup Reverse two-way lookups in a cross reference table [Excel 2016] Reverse […]
Question: How to extract email addresses from this sheet? Answer: It depends on how the emails are populated in your worksheet? […]
In this blog post I will demonstrate methods on how to find, select, and deleting blank cells and errors. Why […]