You will get an error if Flash Fill cannot find the pattern. The first thing to check is that you're using Flash Fill close to the source data (e.g., in the adjacent cell). For instance, it won't work ...

The tilde isn't the only sign you need to understand to truly get your head around Excel's inner workings. For example, the ...

Rajeev Dhir is a writer with 10+ years of experience as a journalist with a background in broadcast, print, and digital newsrooms. Vikki Velasquez is a researcher and writer who has managed, ...