EXCEL Flash Fill

Image result for excel fill flash

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.
Extract Numbers Example
3. On the Data tab, in the Data Tools group, click Flash Fill.
esult:
Extract Numbers ExampleNote: Excel does not insert formulas, if you change the text strings in column A, Excel will not update the numbers in Column B.

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:

Note: again, Excel does not insert formulas, if you change the text strings in column A or column B, Excel will not update the email addresses in column C.

Comments

Popular posts from this blog

[BYAKEMUTSE] My phone is not detected by my computer. It gets charged but I cannot transfer data, why?

HOW to hack your friends WhatsApp account & read all his chats

HOW TO HACK FACEBOOK ACCOUNT FOR FREE