View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
steven steven is offline
external usenet poster
 
Posts: 389
Default Extract file name

What function would extact the name: 84DTCC 2008_05
out of this.
G:\CorporateAcct\SMR\Special\Support\84DTCC 2008_05.pdf

Note that the directory and subdirectory(ies) will not be constant (ie.
some may have more or less "\" )

Thank you,

Steven