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

FLOOR Function

The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the

Read More »

DATEDIF Function

The DATEDIF Function in Excel is used to calculate the number of days, months, or years between two dates. A

Read More »

Autosum Function

Autosum Function Overview The AutoSum Function is by far one of the most useful features in all of Excel. Just

Read More »
Scroll to Top