Hellow guys, Welcome to my website, and you are watching Convert Text to Dates with Flash Fill - Excel Data Cleansing Challenge. and this vIdeo is uploaded by Excel Campus - Jon at 2017-11-15T07:17:09-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Convert Text to Dates with Flash Fill - Excel Data Cleansing Challenge |
| Video Uploader | Video From Excel Campus - Jon |
| Upload Date | This Video Uploaded At 15-11-2017 10:17:09 |
| Video Discription | Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ In this video I explain how to convert dates stored as text to date values that Excel recognizes using Flash Fill. There are many ways to go about this task, so I'm presenting this as a data cleansing challenge to you. I'd like you to share your method for converting this text to a date in the comments below. Download the example file here: https://www.excelcampus.com/tips/convert-text-to-dates-flash-fill/ This question was submitted by Mark, a member of my Pivot Ready Course. He was a column of dates in his data set that are stored as text. Excel does NOT recognize the values as dates, and therefore Mark is not able to sort the column or use it with the date grouping feature of a pivot table. So we must first convert the cells to date values that are recognized by Excel. I share one solution to this problem in the video using the Flash Fill feature of Excel. Flash Fill was introduced in Excel 2013 for Windows, and it's a great tool for data cleansing tasks like this. Of course there are many other ways to solve this problem. Please leave a comment below with your solution. I will then create a follow-up video and explain the suggested solutions. Thank you! :-) Related articles & videos: Article on How Dates Work in Excel: https://www.excelcampus.com/functions/how-dates-work-in-excel/ Video on How Dates Work in Excel: https://youtu.be/KlCAAQ_tQLA |
| Category | Education |
| Tags | excel | excel campus | flash fill | convert text to dates | tutorial | how to |
