Not too long ago, extracting substrings in Excel was a bit of a nightmare. Sure, we've always had functions like LEFT, RIGHT, MID, LEN, and SEARCH to help us, but even the simplest extractions ...