Consider the below example, which shows First name, Last name, and Location combined in one cell.Īssume that we need to extract only the location. In this example, we will see how to extract the specific data from a sentence using Flash Fill. Now we can see that all the data will be filled in automatically, which is shown belowĮxample #4: Extracting data from sentence using Flash Fill But here, we will use the shortcut key for applying Flash Fill.

Apply the flash fill shortcut key, or we can use the Flash fill option in the menu.Now simply type the number within double quotes in cell D2 as – 114/81.Now in this example, we need to extract the first three digits and the last two digits of the social security number. Consider the below example, which has the First name, Last name, and Social Security Number of Individual employees. Let us see how to extract the specific data in this example by following the below steps. The Flash fill tool can combine multiple names, and it will extract the data that we are exactly looking for. In this example, we are going to see how to extract the specific data using Flash Fill. So that all the names will get filled automatically, which saves a lot of time in typing once the flash fill has applied, the result will be displayed, which is shown in the below screenshot.Įxample #3: Extracting Data Using Flash Fill Now apply the Flash Fill shortcut key by holding the CTRL KEY and press E.

First, Create a new column & Type the first name with the last name email id is which is shown below.

Let us see the procedure of doing it by following the below steps. In these scenarios, the Flash fill tool will be very useful where it actually saves more time by filling the data automatically. We can type and complete the process, but it will take a very long time if we have a list of 100 names at a time. Consider the below example, which has First name, Last name, Email id.Īssume that we have the same list with other names with their email id, and we need to combine the first name along with email-id. In this example, we are going to see how to use flash fill with multiple names and email id.

Once we click on Flash Fill, we can see the beauty that all the names will be filled automatically by using them, and we will get the result which is shown below.Įxample # 2: Combining Multiple Names Using Flash Fill.

TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (35+).Excel Conditional Formatting in Pivot Table.

Excel flash fill excel 2010