I have data that was transferred from an Excel workbook where users had entered dates a text and not as a date. There are 18,000 records, so, re-doing them by hand would be unimaginable. I would like to convert the text "Monday, March 11, 2024" into a date format that Access can recognize so it will be searchable. They all seem to be the same format but obviously different string lengths. I've looked at code others have posted but they don't seem to fit what I need to do...can you help?

Thanks!