Results 1 to 2 of 2

Thread: Remove file paths

  1. #1

    Remove file paths



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good day. Is there a formula to remove file paths from the value of cells? For example,

    C:\My Documents\Document1.doc
    C:\My Pictures\Picture1.jpg
    C:\My Music\Music1.mp3

    I need a formula that will scan the value of a cell and when it encounters a backslash, remove the backslash and everything before it.

    So the above example will result into:

    Document1.doc
    Picture1.jpg
    Music1.mp3

    I am not a programmer so I will not understand any suggestions involving scripts. If there is a formula I can just copy and paste that would be best. Thank you for any suggestions.

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Try Ctrl+H
    Replace what : *\
    With : ( leave blank)
    Click " Replace all"
    Done

Posting Permissions

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