Thread: How to extract only file name from folder path string in Excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JayKay JayKay is offline
external usenet poster
  
Posts: 3
Default How to extract only file name from folder path string in Excel?
I need to extract the file names from folder path strings in a worksheet Cell
using Worksheet functions. The number of folder levels is variable:

\\test server\app1\Test Files\File Set1\Bin_S(A)

\\test server\app1\Test Files\File Set2\Test Case1\Full Regression
Reply With QuoteReply With Quote