wizard0
10-07-2015, 12:32 PM
Dear all,
For example I have a string like:
C:/users/library/music/mp3/this-song.mp3
In my sheet I create a hyperlink with that path but I also need to create a hyperlink to the folder of the file.
I tried this:
=LEFT(C:/users/library/music/mp3/this-song.mp3,FIND(C:/users/library/music/mp3/this-song.mp3,"/")
This code gives me C: because the find function finds the first / How can I change the code so that it will keep searching the string for / and take all the chars left of the last one and the last / included.
I do something wrong, please help.
Kind regards,
Wizard0
For example I have a string like:
C:/users/library/music/mp3/this-song.mp3
In my sheet I create a hyperlink with that path but I also need to create a hyperlink to the folder of the file.
I tried this:
=LEFT(C:/users/library/music/mp3/this-song.mp3,FIND(C:/users/library/music/mp3/this-song.mp3,"/")
This code gives me C: because the find function finds the first / How can I change the code so that it will keep searching the string for / and take all the chars left of the last one and the last / included.
I do something wrong, please help.
Kind regards,
Wizard0