How To Quickly Convert Text To Dates With Find And Replace In Excel

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video I explain a shortcut with Find and Replace to quickly convert text to dates in Excel. The example is an Excel file that has been exported from Quickbooks Online. However, this technique will work on any file that has dates stored as text.
Download the sample Excel file: https://www.excelcampus.com/tips/text-to-dates-find-replace

I also explain how to determine that the value in the cell is text instead of a date by using either the number format drop-down menu, or the filter drop-down menu. In the filter drop-down menu the dates will NOT be grouped, and instead listed out individually.

Please leave a comment below with any additional tips or techniques you have for converting these dates to a date data type. Thank you! 🙂👍

Additional Resources:

How the Date Calendar System Works in Excel: https://youtu.be/KlCAAQ_tQLA

Convert Text to Dates with Flash Fill: https://youtu.be/ODaEM5HGLKA

How to Add Days to Dates in Excel:
https://youtu.be/py0FWdN255c
#MsExcel #ExcelCampus
00:00 Introduction
00:12 Converting Text to Date
00:32 Number Format Drop-Down
00:49 Filter Drop-Down
01:39 Use Find & Replace to Evaluate Cells

Видео How To Quickly Convert Text To Dates With Find And Replace In Excel канала Excel Campus - Jon