View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_73_] Steve[_73_] is offline
external usenet poster
 
Posts: 15
Default Remove DateTimestamp from String

All,
I'm working on a macro that works with the name of files in a certain
directory.

My problem is that some of the files may have a datetimestamp within
the filename.

example: "Change 69231 Ticket2008-10-01 14.48.18.953.xls"

Would like to change to "Change 69231 Ticket.xls"


How can I find and delete the timestamp within a string like the
above.

Steve