Excel nugget: Flash Fill

Flash Fill automatically fills your data when it senses a pattern. You are able to separate e. g. first name and surname or split other cell content.

Also it is possible to merge existing cell content of a record from different columns.

As well, you can combine text, which isn´t part of your table or data source, and your existing cell content.

In this tutorial you’ve got 4 options to use the Flash Fill in Microsoft Excel and fill your table with data in no time.

The Flash Fill is part of the Excel versions 2013, 2016, 2019 and Office 365.

Have fun with our nugget.

Regards,

your CARINKO-Team