+ Reply to Thread
Results 1 to 3 of 3

Extract Folder / File Name From File path 4th back slash

  1. #1
    Registered User
    Join Date
    01-24-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    60

    Extract Folder / File Name From File path 4th back slash

    Hi folks,

    how do i extract the file names or folder names after the fourth back slash?

    After some googling i came across this


    =FIND("\",D10,FIND("\",D10,FIND("\",D10,FIND("\",D10)+1)+1)+1)

    it only returns a number -

    Example file path
    C:\Users\Work\Dropbox\Docs\SH23\1. Word
    C:\Users\Work\Dropbox\Docs\PB34\2. Excel

    cheers for any ideas
    sl

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,832

    Re: Extract Folder / File Name From File path 4th back slash

    one option:
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    01-24-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    60

    Re: Extract Folder / File Name From File path 4th back slash

    Thanks Ben,

    done nicely!

    Have a good Evening

    sl

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 12-29-2015, 04:19 AM
  2. Choosing folder path (instead of file path) in VBA
    By sminter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2014, 08:50 PM
  3. Code to list the folder path and sub folder path of a specific file
    By kalai1587 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2013, 03:51 AM
  4. [SOLVED] how to insert file path of every file in a folder as a string?
    By Gamekiller48 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-31-2013, 02:01 PM
  5. Specified folder path to select file path
    By JayEmTee91 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2012, 10:38 AM
  6. Replies: 5
    Last Post: 09-29-2012, 12:40 PM
  7. Replies: 1
    Last Post: 05-24-2007, 07:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1