Excel - Using SEARCH with MID to Extract Text From a Variable Starting Point

Exce's MID() function works well when you need to extract text from a known position within a longer text string. But it that position varies, you need to use SEARCH() to determine the starting point for MID(). This video also looks at what to do when the data you need to extract varies in length.