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 (36+).Excel Conditional Formatting in Pivot Table.

Excel shortcut keys for color fill