You import a messy CSV of names and addresses, reach for Smart Fill or Flash Fill to clean it up, and half the column comes out wrong. Both tools guess a pattern from your data, and both guess badly when the data is inconsistent. Here is how Google Sheets Smart Fill and Excel Flash Fill differ, and how to fix the mis-fills.
