Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a free 3 hour Excel 2019 course from Simon Sez IT ️ https://www.simonsezit.com/four-free-courses

Often, when you?re working with Excel, you have a large amount of data which needs to be subjected to some fairly routine repetitive processing. One of the new features in Excel 2013, which is Flash Fill, can really help with that. The Flash Fill facility of Excel 2013 is a very useful feature that saves you a huge amount of time in typing or putting together a formula to do the job for you.

Get 19 hours of Excel 2013 training here course here: http://streamskill.com/course/ultimate-microsoft-excel-2013-training-course/

Stay in touch:
StreamSKill.com: http://streamskill.com/
SimonSezIT.com: https://www.SimonSezIT.com/
The Simon Sez IT email newsletter: http://bit.ly/18bMwY0
YouTube Channel: http://bit.ly/foiItB
Twitter: http://bit.ly/177EU5J
Google+: http://bit.ly/11JbHdb

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)

Hello again and welcome back to our course on Excel 2013. It’s very often the case when you’re working with Excel that you have a large amount of data which needs to be subjected to some fairly routine repetitive processing. And one of the new features in Excel 2013, which is Flash Fill, can really help with that. And I’m going to demonstrate Flash Fill using one or two specific examples.
Now the examples I’m going to use are based on the worksheet that you can see in front of you.

And in this worksheet, I’ve got some very simple data about some of my customers. I’ve got their home phone numbers, seven digits, and I’ve got last name and first name of each of the customers. And what I want to do is to make a couple of new columns out of this data and I’m going to get Flash Fill to help me to do it.

Now the home phone numbers that I’m using on the left are obviously not complete numbers. They’re just the last seven digits of those numbers. And normally when you see those numbers written out, they will be written out in a format like this: 395-6492. And what I’d really like is for each of those phone numbers to have that hyphen put in the relevant position.

Now if you’ve used Excel before, you’ll know that you could write a formula using some string functions in Excel to do that for you and to automate this process and that would be absolutely fine. It’s the sort of thing we’re going to look at later on.

But Flash Fill offers you an even quicker way of doing it. Having entered one of those numbers correctly, if I go to the second one and just start typing the second one, so the second one will be ultimately be 722-9845, watch what happens if I just type the seven. Basically Flash Fill or more specifically Excel with the help of the Flash Fill facility looks at the whole of the Column next to the one I’m working in and it works out what each of the other should be based on what I’ve done in the first one.

So it uses the first one as a sort of model and it says okay, I can see what you’re doing there. Well, if I applied the same principle to the rest of the column this is how all of the others would look. Now I can look at all those and I can say actually, that’s absolutely right. They’ll all be absolutely correct. And then all I have to do is to press the Enter key and the whole lot is accepted. Just think how much work that saved me being able to do that. Now in this case, I’ve only got somewhere between 20 and 30 phone numbers, but if I had hundreds or thousands that would be a huge time saver.

Now if you experiment with Flash Fill a little, you will find that you can actually achieve some pretty sophisticated affects with it. And in the next example, I’m going to actually two columns and combine the content of two columns. I have here, for example, last name and first name. And let’s suppose that I want to put together a complete name, a whole name for each of these people. And I’m going to do it in this format. I’m going to do Hilda Anderson. Okay, that’s how I want them to look. So the next one will be Ray and as you can see once again it’s worked out what they should all be.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.