EXCEL Flash Fill
Use flash fill in Excel 2013 or later to automatically extract or combine data.
Extract
1. For example, use flash fill to extract the numbers in column A below.
2. First, tell Excel what you want to do by entering the value 4645 into cell B1.

3. On the Data tab, in the Data Tools group, click Flash Fill.
esult:

Join
1. For example, use flash fill to join the last names in column A and the first names in column B to create email addresses.
2. First, tell Excel what you want to do by entering a correct email address in cell C1.
3. On the Data tab, in the Data Tools group, click Flash Fill.
Result:
Comments
Post a Comment
Andika igitekerezo cyubaka gusa!