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

WORKDAY Function

The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user

Read More »

What is VBA in Excel?

VBA VBA, which stands for Visual Basic for Application, is a programming language developed to work with Microsoft’s Office applications

Read More »

MAX Function

The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells,

Read More »
Scroll to Top