If I have a bunch of files in a folder with the name "Daily Numbers Report -Summary_2014-01-28-06-02-26" how can I cut off all the numbers in the title after "1-28"? The name format is the same for all files.
If I have a bunch of files in a folder with the name "Daily Numbers Report -Summary_2014-01-28-06-02-26" how can I cut off all the numbers in the title after "1-28"? The name format is the same for all files.
check out the LEFT() function....it should help you....
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
No, I need a macro because these are names of workbooks.
will this help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks