
This Excel tutorial explains how to convert a column with Date and Text to Date.
Excel convert column with Date and Text to Date
Excel has a built-in Function DateValue, which converts a Date in Text format to date serial. What if the column contains both Text and Date? If you use DateValue Function on Date, #VALUE! will return. So how can we convert Text and Date at the same time?
Convert Text to Date in Notepad
The below method is even faster than DateValue Function or Text to Column, it i...
Read More