Problem: How will Flash Fill get this right? Even I wouldn't know what to fill in next?
Strategy: Before invoking Flash Fill with Ctrl+E, provide enough examples to establish the pattern. If you invoke Flash Fill from B3, you will get the prefix instead of the suffix. By filling in one more example and running Flash Fill from I4, you will get the suffix.
- Give Flash Fill enough examples.