Explanation: ●《《

Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last NAMES from a single column, or combine first and last names from TWO different columns.

☆ Note: Flash Fill is only AVAILABLE in Excel 2013 and later.

Let's say column A CONTAINS first names, column B has last names, and you want to fill column C with first and last names combined. If you ESTABLISH a pattern by typing the full name in column C, Excel's Flash Fill feature will fill in the rest for you based on the pattern you provide.

1- Enter the full name in cell C2, and press ENTER.

2- Start typing the next full name in cell C3. Excel will sense the pattern you provide, and show you a preview of the rest of the column filled in with your combined text.

3- To accept the preview, press ENTER.

If Flash Fill doesn't generate the preview, it might not be turned on. You can go to Data > Flash Fill to run it manually, or press Ctrl+E. To turn Flash Fill on, go to Tools > Options > Advanced > Editing Options > check the Automatically Flash Fill box. ● 》》