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

Thank you, Michael!

My son's name is Michael, too!

:o)
--
Regards,
John


"Michael" wrote:

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