Excel Forum
Similar Content
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
6 Tricks to Make Dates Work in Excel
Tutorial: Watch this tutorial if you work with dates! Quick and easy ways to reliably convert dates...
3 Methods to Remove Spaces Between Text in Excel
Tutorial: How to remove spaces from the middle of text in Excel.  This includes removing all space...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Mr Excel & excelisfun Trick 51: Extract Dates from Cell With Dates and Words


See Mr Excel and excelisfun Extract Dates from Cell With Dates and Words using two different methods. See the functions: DATEVALUE, RIGHT, IFERROR, LEN, TEXT, SEARCH, TRIM, REPLACE, and adding zero to convert dates as text to dates.





Got a Question? Ask it Here in the Forum.