Dates through Text to Columns Post author:Author Post published:October 3, 2016 Post category:Excel Tips 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 training course from AdvantEdge Training & Consulting! You Might Also Like Use =left and =concatenate to create a list of email addresses from Excel October 3, 2016 Finding Worksheets in Excel January 17, 2019 Excel Formula for Today's Date September 30, 2016