I learned about an interesting new feature in Excel 2013 which they call “FLASH FILL”. Instead of trying to explain it, Let me demo it:
1. I’ve following data in Excel 2013:
2. Now the requirement is to split the FULL NAME into FIRST NAME and LAST NAME.
So I entered Kim in cell B2
Then I typed just Mi in the cell B3 and Excel 2013 predicts correctly for cell B3, B4 and B5 that I am filling up the first name from the Full Name column.
I hit enter for the column First Name.
I performed similar steps for the column Last Name. And there you have it:
That’s about it for demo of Excel 2013’s Flash Fill – very cool!
I’ve posted how to split the values in a column for Excel 2010, you can read that here: How to split the content of one excel cell into separate columns?
Your comments are very welcome!
I was playing with Excel 2013 and wanted to see the Formula Bar for something. Turned out, by default, It was hidden and so I learned how to unhide it. Here are the steps:
1. Go to View Tab
2. Check the “Formula Bar” check-box:
3. And it’s unhidden now!
In this blog-post, we saw how to unhide the formula bar in Excel 2013.