This is the demonstration file referenced in How to combine Excel's VLOOKUP() function with a combo box for enhanced searching, by Susan Harkins.

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.