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
Bookmarks