In this case, providing just one example was enough. The example shows how you can use Flash Fill to create an email address from three separate columns containing the first name, last name and company name. Excel will guess the pattern and fill in the rest of the data for you. You only need to provide a couple examples of the results you want. Potential Remedies When Flash Fill Failsįlash Fill is a data tool in Microsoft Excel that will allow you to combine, extract or transform data based on a few examples.