10 January 2016
Flash Fill is like a copy cat, which can do the things in same pattern in which you are doing. You just have to do that operation once & Flash Fill do it for the rest. It can help you to make your data entry much easier & make you less dependent on complex formula for little things.
This article includes 10 examples of using Excel's Flash Fill feature, showing you how to use it to manage your data effectively.
Full article: How to use Flash Fill in Excel – 10 useful examples