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

Three Bags Full, Sir/Madam

From time to time, I am asked to do things that make no sense to me (but I know we are all different). One such request was to concatenate the contents of three columns in Excel into a single column, but with fixed width for the results,... Continue →