We have addresses, each containing the street number. Let’s look at another example, which is a bit more complex. This is an important fact to keep in mind! Data won’t dynamically change after using Flash Fill. The data that was filled in doesn’t change after changing the original data! If we now change the year of the first date, the year in the year column (which was filled using Flash Fill) doesn’t change. Sample table of datesĮxcel performs the Flash Fill and we get the column of years. We confirm this with a press of the Enter key. As we start typing in the second entry, Excel provides the correct data. Once we get our Flash Fill results, they don’t change if we change the original data. The result we get is now correct – Excel recognizes both one or two first names. We then select the entire column that needs to be filled and Home > Fill > Flash Fill. We first fill the “odd” entries, so Excel can learn from the data we provide We fill out the first entry with two first names. Sample table where some entries have two first names Some people have two first names, which is why we must provide at least one sample row for Excel to recognize what we want. As we start filling out the second name, Excel offers to fill the data, but it’s not what we want. In the table below, we fill out the first name. What about cases where we have two first names? We now have the exact right table we wanted. Suggested answers based on the first rowĮntries are correct so we can just confirm it by pressing Enter. (Note that sometimes it takes more than one sample manual input to start working).
To start with, we manually write in the first Name – Last name combination.Īs we start filling out the second name, Excel offers to fill out the rest of the table with the following entries. We would like the third column to consist of the first name in capital letters and the last name as is. Let’s start with a simple table of first and last names. Depending on the complexity of our data, we may need to do some trial and error tests before we get the desired result. We initially have to fill in some data and then Excel does the work for us. It works by recognizing patterns of filled data and filling out the rest. Welcome to the brave new world of Artificial Intelligence in Excel! In this article, we’ll look at a powerful new feature called Flash Fill.
0 kommentar(er)
