For decades, anyone working with text data in Excel has been limited to the same old functions for separating or parsing text strings. But recently…