Convert Text to Dates with Flash Fill - Excel Data Cleansing Challenge
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
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/conv...
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...
Video on How Dates Work in Excel: • Understand How The Date Calendar Syst...
Смотрите видео Convert Text to Dates with Flash Fill - Excel Data Cleansing Challenge онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel Campus - Jon 15 Ноябрь 2017, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 24,991 раз и оно понравилось 349 людям.