You can use the 'Text to Columns' feature in Excel to remove the separators from the dates. Select the column with the dates, go to the 'Data' tab, click 'Text to Columns', choose 'Delimited', uncheck all delimiters, and click 'Finish'.