Strip filename from path with Excel formula

login | register | shoutbox

What happened to the Messenger Plus! forums on msghelp.net?

Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » Strip filename from path with Excel formula

Strip filename from path with Excel formula

Author:

Message:

CookieRevised
Elite Member

Posts: 15517
Reputation: 173
– / Male

Joined: Jul 2003
Status: Away

O.P.

Strip filename from path with Excel formula

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:
=EXTRAE(A1;ENCONTRAR("*";SUSTITUIR("\" & A1;"\";"*";LARGO(A1)-LARGO(SUSTITUIR(A1;"\";""))+1));LARGO(A1))

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.

PS: to translate functions, you can use this page as a guideline: http://dolf.trieschnigg.nl/excel/excel.html

Attachment: Map1.zip (2.17 KB)
This file has been downloaded 135 time(s).

This post was edited on 06-30-2005 at 12:46 AM by CookieRevised.

.-= A 'frrrrrrrituurrr' for Wacky =-.

06-30-2005 12:39 AM

« Next Oldest

Return to Top

Next Newest »

Messages In This Thread

Strip filename from path with Excel formula - by CookieRevised on 06-30-2005 at 12:39 AM

RE: Strip filename from path with Excel formula - by lopardo on 06-30-2005 at 03:35 AM

RE: Strip filename from path with Excel formula - by CookieRevised on 06-30-2005 at 03:56 AM

Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites

Forum Rules:
You cannot post new threads You cannot post replies You cannot post attachments You can edit your posts	HTML is Off myCode is On Smilies are On [img] Code is On