Using TextJoin

Jan 25, 2018 | Excel, Functions, Text Functions

          TextJoin() TEXTJOIN is a text function that was introduced in Excel 2016 to join text in cells together. Initially, you may think that the function is not that worthwhile. After all, we already have the ampersand (& ) as well as...

LEN Function

Aug 18, 2016 | Functions, Text Functions

LEN Function – Counting Characters in a Cell LEN() is one of those functions that you wonder about. LEN is a text function and depending upon what you are doing it is so useful. It counts the number of characters in a cell.  I use it all the time if I want to...

An Automated Alternative in Excel

Aug 12, 2015 | Text Functions

Automated alternative to FlashFill (and the “Text to Columns” Wizard) My Excel tip is not so much about a favorite “tip or trick” as it is about a favorite concept. Tools like FlashFill and the “Text to Columns” Wizard are neat and...