logo-wlogologo-wlogo-w
  • Home
  • Classes
  • Training
  • Consulting
  • Blog
  • Contact
✕
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

Magic of Flash Fill

October 4, 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

Example 2

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.

Example 3

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.

Example 4

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.
Contributor Image Raj
Share
5

Related posts

December 16, 2021

Stacking in EXCEL


Read more
December 9, 2021

SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW


Read more
November 25, 2021

Circular Referencing Solution


Read more

Comments are closed.

✕

Categories

  • Google
  • MS Excel
  • MS Word
  • Power BI
  • Uncategorized
  • Stacking in EXCEL
    December 16, 2021
  • SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW
    December 9, 2021
  • Tips and Tricks of MS PowerPoint
    December 3, 2021
  • Circular Referencing Solution
    November 25, 2021
  • Printing tricks
    November 18, 2021
    Disclaimer Policy | Terms of Service
    Powered by Aswini Aswini Bajaj
    Website Designed & Developed by 'A PIXEL HOUSE'