Dates through Text to Columns If the DateValue Command doesn’t work, use text to columns to reformat text into dates. For more ways to make Excel work for you, take a live or online training course from AdvantEdge Training & Consulting! You Might Also Like Tab Between Worksheets in Excel October 5, 2016 Use =left and =concatenate to create a list of email addresses from Excel October 3, 2016 Excel 3D References September 30, 2016