Posted to microsoft.public.excel.programming

Steve[_73_] Steve[_73_] is offline

external usenet poster

Posts: 15

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove the right most 3 characters from a string	Jonathan Brown	Excel Programming	10	October 29th 08 10:44 AM
remove text from string	Todd	Excel Worksheet Functions	3	May 25th 06 11:10 PM
Remove specified value from string	Todd Huttenstine	Excel Programming	1	January 31st 06 07:32 PM
Remove specified string from value	Todd Huttenstine	Excel Programming	1	January 31st 06 05:13 PM
Remove specified value from string	Todd Huttenstine	Excel Programming	2	January 31st 06 04:48 PM

All times are GMT +1. The time now is 08:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us