Flash Fill it Excel
A lot of times the data you have to work with in Excel isn’t quite the way you need it to be, and going through a giant set of data to manually correct it is monotonous and time-consuming. Sure you can do a lot of things with a few crafty formulas but once you see what the Flash Fill function can do you’ll be totally amazed.
Excel 2013’s Flash Fill feature allows you to take a part of the data entered into one column of a worksheet table and enter just that data in a new table column using only a few keystrokes.
As soon as Excel detects a pattern in your initial data entry it ‘smartly’ figures out the data you want to copy offers a way to type the rest of the data for you. Accept it and the rest of the cells are automagically transformed!
And the cool thing…
View original post 180 more words