fbpx

All articles with 'Textjoin()' Tag

VLOOKUP multiple matches – trick

Published on Apr 16, 2019 in Excel Howtos, Learn Excel
VLOOKUP multiple matches – trick

We all know that VLOOKUP can find first match and return the results. But what if you want all the matches? Use this simple trick instead.

Continue »

Formula Forensics 042: Reverse Text – A Formulaic Solution

Published on Jan 4, 2017 in Formula Forensics, Huis, Posts by Hui
Formula Forensics 042: Reverse Text – A Formulaic Solution

Use the new Textjoin() function to reverse a string of characters suing a formulaic solution.

Continue »