Stop manually reformatting Excel spreadsheets. The Spill Manager add-in makes your formatting move dynamically with expanding arrays.

Have you ever found yourself staring at a sea of blank cells in Excel, wondering how to fill them without hours of manual effort? For years, this has been a frustrating bottleneck for professionals ...

The introduction of dynamic arrays triggered the biggest change to how we work with Microsoft Excel formulas in years, if not decades. They allow a single formula to spill multiple results into ...

This post explains how to use the new Excel TEXTSPLIT function. TEXTSPLIT() is a Text function in Excel. The purpose of this function is to split a given text string on the basis of one or more ...

If you often work with data that starts life as a text file or CSV, Microsoft Excel now has new built-in tools that simplify how that information gets pulled into a spreadsheet. The update introduces ...

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more. Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating ...