Recently Microsoft has introduced a game-changing set of functions in it’s Excel spreadsheet software that harness the power of Regular Expressions (REGEX) to streamline data extraction, cleaning, and ...

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but the ...