Strip filename from path with Excel formula - Printable Version
-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: Strip filename from path with Excel formula (/showthread.php?tid=47016)
Strip filename from path with Excel formula by CookieRevised on 06-30-2005 at 12:39 AM
This one is for Lopardo (because he said on IRC he was too lazy to translate a formula into spanish 
)
I think it should be this in Spanish:
code:Note: this isn't exactly the formula you've found, but it is based upon it (read: fixed). The formula you've found would have given an error if no path was given.
=EXTRAE(A1;ENCONTRAR("*";SUSTITUIR("\" & A1;"\";"*";LARGO(A1)-LARGO(SUSTITUIR(A1;"\";""))+1));LARGO(A1))
PS: to translate functions, you can use this page as a guideline: http://dolf.trieschnigg.nl/excel/excel.html
RE: Strip filename from path with Excel formula by lopardo on 06-30-2005 at 03:35 AM
Hey Cookie, thanks, it worked fine. 
BTW, here's something interesting for translating functions, haven't tried it yet though: http://members.chello.nl/keepitcool/download.html
RE: Strip filename from path with Excel formula by CookieRevised on 06-30-2005 at 03:56 AM
thanks for the link... hmmm maybe this should be in TechTalk afterall.....