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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |