When it detects a pattern, Flash Fill automatically fills your data. Flash Fill can, for example, be used to split first and last names from a single column or to combine first and last names from two different columns. Please keep in mind that Flash Fill is only possible in Excel 2013 and later.
Vishalini.R Edited answer June 26, 2023
