Flash Fill in Excel

Flash Fill This is an Excel feature that was first introduced in Excel 2013 as an alternative to simplify data cleaning process considered very difficult, time consuming, or not possible with existing methods. The way it works is similar to that of Text-to-Column but can handle the task of cleaning huge data in more faster[…]

Shares 0

Text to Column

As it name implies, it can be used to split bunch of data separated by either space, comma or other separators to unique fields (columns). This function is very handy while import large file from text editor or web. Let’s illustrate this by splitting data below to columns Highlight the cells range >> Go to[…]

Shares 0