How to Use Flash Fill in Excel 2013 and 2016 (14 Awesome Examples)

This amazing feature - Flash Fill was introduced with Microsoft Excel 2013 and have been one of the trending feature of 2013 launch till date. This feature killed many functions' use and can do the task in fraction of seconds for you single handedly.

It recognizes the pattern you provide and then does rest of the task by its own. It can solve the purpose of CONCATENATE, LEFT, RIGHT, MID, Reversing Data, Extracting, Serving the purpose of TEXT Functions and many more. You can also use CTRL + E to perform this feature in a second and you get the result in next fraction of seconds.

In this video, I've talked about 14 Examples as follows which can be used in day to day life of anyone.

Ex01. @01:08 : Extract First Name and Last Name
Ex02. @02:18 : Extract Initial Letter of First Name & Last Name
@02:51 : Changes are not recognize by its own like a formula
Ex03. @03:14 : Extract Initials in a column
Ex04. @03:36 : Get First 2 Characters of First & Last Name
@03:55 : Feature may return incorrect result when Flash Fill does not recognize the pattern correctly.
Ex05. @04:39 : Get First Name and Initial of Last Name
Ex06. @05:07 : Flip (Reverse) First Name and Last Name
Ex07. @05:30 : Merge First Name and Last Name Together
Ex08. @05:55 : Merge Last Name Separating by Comma and Space with First Name (Include any special character or punctuation in text)
Ex09. @06:19 : Extract 5 character code from middle of the code
Ex10. @06:47 : Change Incorrect Entries of Date into Correct Date Format
Ex11. @08:17 : Extract Date Components (e.g. Year, Month or Day only)
Ex12. @08:53 : Convert Date into plain number format
Ex13. @09:34 : Format Phone Numbers into any country's phone number format
Ex14. @10:19 : Extract Only User Name from Email ID

There can be many more examples wherein you can use Flash Fill feature. Along with the advantages, it also has disadvantages. If the provided pattern is incorrect or feature is unable to understand the pattern, Feature will not return anything and might show warning. Also, if any changes made to the data post performing Flash Fill, result won't update as it gets update when using Formulas.

Learn more at www.OnlineExcelTip.com

Видео How to Use Flash Fill in Excel 2013 and 2016 (14 Awesome Examples) канала Analytics Training Hub