Flash Fill is a powerful Excel feature that detects patterns in your data and fills in the remaining cells automatically. It is perfect for splitting names, formatting phone numbers, or cleaning up messy text.
نفّذه بالذكاء الاصطناعيPrepare your data
Ensure your source data is in a column immediately to the left of the empty column where you want the results.
Provide an example
Type the desired output for the first row manually in the adjacent cell to establish the pattern.
Trigger Flash Fill
Press Ctrl + E on your keyboard, or go to the 'Data' tab and click 'Flash Fill' in the 'Data Tools' group.
No, Flash Fill is a static operation. If you change the source data, you must run it again or use a formula instead.