Flash Fill Excel 2007. Enable flash fill in excel. Click file options.
Flash fill did not correctly extract the decimal numbers only the digits after the decimal point. Notice the small box that s appeared in the bottom right of the selected cell b3. Excel flash fills the rest of the product ids for you.
Close and restart excel.
Close and restart excel. On the data tab in the data tools group click flash fill or press ctrl e. Click file options. To accept the preview press enter.