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 ...

Lorraine Roberte is an insurance writer for Investopedia. As a personal finance writer, her expertise includes money management and insurance-related topics. She has written hundreds of reviews of ...