+ Reply to Thread
Results 1 to 2 of 2

How to Extract Folder Path from SharePoint address by Formula?

  1. #1
    Registered User
    Join Date
    11-15-2019
    Location
    hk
    MS-Off Ver
    2016
    Posts
    7

    Question How to Extract Folder Path from SharePoint address by Formula?

    How to Extract Folder Path from SharePoint address by Formula?
    Output: ROOT/ABC XCFR/4. Malaysia/12. Inventory
    Input:
    http﹕∕∕abc-xyz-team.global.company.com/Shared%20Documents/Forms/AllItems.aspxRootFolder=%2fShared%20Documents%2fJSG%20XCFR%2f4%2e%20Malaysia%2f12%2e%20Inventory&FolderCTID=0x0120005DFB589EE8C40A4D966339377123403D

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: How to Extract Folder Path from SharePoint address by Formula?

    Assuming this value is in A1 then I *think* this works:

    Please Login or Register  to view this content.
    WBD
    Attached Files Attached Files
    Office 365 on Windows 11, looking for rep!

+ 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. File Path Formula for the sub Folder
    By jasond1992 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-18-2021, 01:25 AM
  2. Find path to local synced sharepoint folder
    By rob vandebergh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-16-2020, 01:06 PM
  3. concatenating the defualt path of browsefolder() to the user input path or folder name
    By Neverending1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2018, 09:52 AM
  4. [SOLVED] Extract Folder / File Name From File path 4th back slash
    By sl729 in forum Excel General
    Replies: 2
    Last Post: 08-01-2016, 02:18 PM
  5. How to validate an input dat folder/directory path whether the path has any spaces
    By mahendra.asapu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2015, 02:39 AM
  6. 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
  7. Replies: 1
    Last Post: 05-24-2007, 07:28 AM

Tags for this Thread

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