Excel Flash Fill - GoTo Special Options

Workbook: https://drive.google.com/file/d/1xb9Lb8m1MwiaWocGe6blYOYcnBwZy9z0/view?usp=sharing

1. Use the Excel shortcut key for Flash fill: Control + E
2. Pull down the values with the fill handle and then select Flash Fill
3. Go to Home / Fill / Flash Fill
4. Start typing the 2nd value and once Excel recognizes the pattern, you will see the results shown in the cells in light grey. Just press Enter.

Without formula join text with excel flash fill
Without formula separate text with excel flash fill
Without formula, you can switch the date with excel flash fill

Thanks for watching, please do Subscribe!!

Видео Excel Flash Fill - GoTo Special Options канала Update Tech Skills