converting website visitors
Microsoft Office Tip & Tricks Menu
Tip & Tricks Menu

Excel 2013 - Flash Fill

Monday November 3, 2014 at 9:29am
Easily the best new feature in Excel 2013, Flash Fill solves one of the most frustrating problems of Excel: pulling needed pieces of information from a concatenated cell. When you’re working in a column with names in “Last, First” format, for example, you historically had to either type everything out manually or create an often-complicated workaround. Flash Fill can automatically add data formatted the way you want without using formulas. In Excel 2013, you can now just type the first name of the first person in a field immediately next to the one you’re working on, and click Home > Fill > Flash Fill, and Excel will automatically extract the first name from the remaining people in your table.
» Categories: Microsoft Excel

Comments

There aren't any comments for this post yet. Why not be the first to comment?

Leave a Comment

Your Name
  
Email Address (kept hidden)
  
Website
 
Comment
  

So that we can check that you are a real person (and not a crafty computer),
answer this simple sum:

What is 18 - 6?
  
Intec Business Colleges - Established For Over 30 Years
Microsoft Office Specialists - Approved Microsoft Courseware
Intec Business Colleges Ltd, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411 email:tracey.chaplin@getoncourse.net
Website Design by ZARR Ltd