#Flash Fill feature in Excel very useful for GIS users#
In Microsoft Excel, the Flash Fill feature is typically found under the "Data" tab in the ribbon. Here's how you can access and use the Flash Fill command:
Enter Data: Start by typing the data in the column where you want to apply the Flash Fill transformation.
Adjacent Column: In an adjacent column, type the desired transformation for the data. This adjacent column serves as a guide for Excel to understand the pattern you want to apply.
Apply Flash Fill:
After typing a few examples of the transformation in the adjacent column, Excel might automatically detect the pattern and display a preview of the changes.
Excel Flash Fill Major Time Saving feature, If you establish a pattern by typing the full name in one column, Excel's Flash Fill feature will fill in the rest for you based on the pattern you provide. Enter the full name in adjacent cell , and press ENTER. Go to Data Flash Fill, or press Ctrl+E. Excel will sense the pattern you provided in adjacent column, and fill the cells below. Shortly Flash Fill is a Magic command in Excel for More details please watch this video.

For more Best tutorials visit and subscribe ‪@bestsolutionline‬