Using TextJoin

by CPA Self Study | 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

by CPA Self Study | 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...

An Automated Alternative in Excel

by CPA Self Study | 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...