I have over 6,000 pdfs that have a date and the number of the pdf. For example:

March_15_2011_00001.pdf
March_14_2011_00002.pdf

The numbers go up and I need to get rid of them while keeping the dates. Is there a way to do this with excel?

Thanks!