What is Excel Flash Fill?

Flash Fill is a time-saving feature which fills in data for you when a pattern is evident. It can also can extract and insert as well as format and concatenate. It can also reverse text, numbers and dates.