Learn how to use the FLASH FILL in Excel. Flash Fill quickly looks at similar cells and automatically picks up commonalities.

Let’s look at the following data set. In Row 4, you see “Joe, .324, 185.” This data is all in the same cell. By typing .324 in cell B4 and 185 in cell C4, you can use the Flash Fill tool to automatically split the remaining columns.

Flash Fill in Excel

Go to the Data Tab, Select Cell B4, then hit the Flash Fill button.

Excel will automatically split and populate the results in column B. Now, do the same thing for column C.

Flash Fill Demo in Excel

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend