Several years ago, I wrote a blog post demonstrating how to do string manipulations like the above examples. Today I’m proud to be writing about a new feature in Excel 2013 called Flash Fill that makes all of those tasks very simple for even the most novice user. ![]() Because the data came from a database, I often had to make sure the names had Proper Casing (e.g. I had to change the format & display of dates, social security numbers, and dollar amounts. Sometimes I only needed first name initials, put together with the last name. I would join first names and last names together into a single column of text. I would extract first names, last names, and email addresses from chunks of text. To try out this new feature download the Office Preview here.īefore coming to Microsoft I spent a good deal of time messing around with data. This post is brought to you by Chad Rothschiller a Program Manager on the Excel team.
0 Comments
Leave a Reply. |