View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pam[_7_] Pam[_7_] is offline
external usenet poster
 
Posts: 15
Default Choping Up a String

Hi

I was wondering if anyone new exactly how to use the chop function
to chop up a string. Basically what I am trying to do is chop up thre
namer of
a file which contains the filename with date. I want to get the date
for that file
name; Here is an example

MY Sheet_070327_US.xls

I want to chop it up so I just end up with the date.



Your help is appreicated. Thanking you in advance


Pam