This live demo puts a bow on the text parsing series Chad Adams has prepared. If this is your first look at series you might want to review each function in more detail. There’s a list of links below to make that a bit easier. Go forth and parse text to your hearts content! Left functions video. Right functions video. Middle functions video. PatternCount function video. Substitute and GetValue functions video. The first demo in this series. It’s a must see!