Excel – Tip – Separating Data within a Cell

Now that you know how to filter and sort – what do you do when there isn’t a column with just the data you need? If you have a column which contains that information but it is mixed in with other information, this video will show you one way to separate out that information. Once you have pulled out the specific information you need into a separate column, you can then filter and sort just as you learned in the first tutorial.