TEXTJOIN Archives - Xelplus - Leila Gharani

How to Properly Use the Excel TEXTSPLIT Function

Leila Gharani — Thu, 31 Mar 2022 08:00:00 +0000

Excel's TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.

The post How to Properly Use the Excel TEXTSPLIT Function appeared first on Xelplus - Leila Gharani.

Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values)

Leila Gharani — Thu, 29 Jul 2021 08:00:00 +0000

Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.

The post Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) appeared first on Xelplus - Leila Gharani.

How to Get Multiple Match Results in Excel Without the FILTER Function

Leila Gharani — Thu, 28 May 2020 09:00:00 +0000

If you don't have the Filter function in Excel, you need to check out this easy formula approach to get multiple match results in Excel. Download the workbook and use the version that fits your problem best.

The post How to Get Multiple Match Results in Excel Without the FILTER Function appeared first on Xelplus - Leila Gharani.

Excel Complex Lookup: Find Header

Leila Gharani — Tue, 05 Sep 2017 09:52:00 +0000

In this tutorial we tackle a complex lookup problem - how to return the header based on criteria in a matrix. I offer my solution using INDEX and SUMPRODUCT. We also cover alternative approaches proposed by the Excel community, including an interesting TEXTJOIN solution that is able to handle multiple match results.

The post Excel Complex Lookup: Find Header appeared first on Xelplus - Leila Gharani.