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.
Bookmarks