Here is where the magic of VBA (Virtual Basic for Applications) comes in. It's an undiscovered Excel feature for creating custom functions, which has entirely changed how I handle my spreadsheets.

How to use the new TEXTSPLIT() function in Microsoft Excel Your email has been sent Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating or returning a ...