Between the Sheets, Episode 70: Dynamically extract data from cells

When you have cells containing a lot of data and you need to extract just part of each cell, there are several ways you can try, but Excel doesn’t have a built-in way of doing it dynamically. Think of house numbers in long addresses. You can use the text-to-columns feature to split the cells into multiple columns, then keep the column you want, but it’s messy and not dynamic. But there are two functions you can use together to get the job done. That’s what we do in this video.