 In this training video, we're going to look at a feature in Excel called Flash Fill. So we've got names in column A where we got the sales rep by first name and surname in one column. This is often not very good for filtering and sorting purposes. So we can now separate these by using a feature called Flash Fill. So if I click on cell B2 and we'll go to the Flash Fill feature, which is on the data tab and it's the option here called Flash Fill. So I'm first going to type in Alice and then I'm going to highlight Alice down to the last first name. And then I'm going to ask to apply the Flash Fill. So what it's going to do is going to look at Alice. It's going to see that's the first name extracted and it's now going to take the first name out of each of the names within column A and put it into column B and very cleverly all of the first names are now by themselves. We can do the same with the first surname, with the first cell selected, highlight the rest of the range, Flash Fill. And now we'll get all the surnames. And now we've separated column A into column B first names and column C surnames using the Flash Fill feature. So this is a useful way of separating information if you've got information that's all in one column. This completes the training video on the Flash Fill feature. If you enjoyed this video make sure you like and subscribe to our channel. Hope to see you for the next tutorial and thanks for watching.