5 MS WORD HACKS TO MAKE YOUR LIFE EASIER
October 2, 2019
Spare 30 Seconds and get Insight to 6 Amazing Features of POWER BI!
October 18, 2019
Flash fill is an awesome tool which magically fills data once it identifies a pattern.
The tool justifies its name by executing a task that would normally take hours, in a “Flash”.
Location – Data Tab – Data Tools
Shortcut – Ctrl + E
Use – Input manually in the first cell and let Excel predict the rest by pressing Ctrl + E in the next cell.
Examples: –
1. Flash Fill to Join Columns
Combining the columns to make a complete address is easy, just input in the first cell, go to the next cell and press Ctrl + E
2. Flash Fill to Extract Data
Now you can extract the pin code out of the same address
3. Flash Fill to Format and Clean Data
You can also edit the names as per a certain format or clean up the data by getting rid of extra spaces as seen below.
4. Forming Emails
Instead of using the tedious and long formula with concatenate, you can use flash fill to do the same thing effortlessly as seen below.
Contributor: Raj Rajeshwar Sharma
Third year B.Com (Hons) student at St. Xavier's College, Kolkata. I am pursuing CFA. I have been working at Leveraged Growth as a Finance intern for the past 3 months. I am a Finance enthusiast with keen interest in learning different programming languages.
