Learn how to use the FLASH FILL feature 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 Example

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 Reply

What is a Macro?

Macro is just the name given to the codes written in VBA. So our codes, henceforth, will be referred to

Read More »

YEAR Function

The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to

Read More »
Scroll to Top