View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Pulling the last 6 characters out of the filename

myvar= right(mystring,6)
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"John Brenner" wrote:

I've got the right file open and all my numbers are crunching nicely - but I
need to drop in the date of the "data conversion" which is contained in the
last 6 characters of the filename.

How do I pull those last few characters out of the filename and drop it into
my string?
--
Regards,
John