Excel: Flash Fill

Of all the new features in Excel 2013, the biggest time saver for me is Flash Fill. It’s like Text to Columns on steroids:

excel1.png

The example shows a list of Surname/Name pairs, separated by comma.

To change them to Name/Surname (without a comma), just type an example of the output you want in the top adjacent cell (B1 here). Select the whole adjacent range as above, click the Home Tab, Editing Group (far right of the ribbon), and Fill.

The last entry in this drop-down is Flash Fill. Click that, and this is the result:

excel2.png

It doesn’t get any easier than that!

Bio: This article was written by Jasper Cook, Excel guru and trombonist of note. Call or email us if KRS and Jasper can assist you with your Excel: enquiries@krs.co.za

 
0
Kudos
 
0
Kudos

Now read this

Excel – Using the CELL function

Here’s a small selection of useful functions, including CELL, MID and FIND. Typing “=CELL(“ in Excel will drop this menu down. Most are self-explanatory, but there are some uses for CELL with filename that are “different”. For example,... Continue →