This formula is used to Find the last occurrence of a Character in a String in Excel

This formula is used to Find the last occurrence of a Character in a String in Excel
the reason for this is thst when working with long filenames the last instance of "\"is where the filename starts
the formula is :
=SEARCH("+-+",SUBSTITUTE(D3,"\","+-+",LEN(D3)-LEN(SUBSTITUTE(D3,"\",""))))

Comments

Anonymous said…
Amiable post and this fill someone in on helped me alot in my college assignement. Gratefulness you as your information.
Thursday, March 11, 2010
Anonymous said…
Sorry for my bad english. Thank you so much for your good post. Your post helped me in my college assignment, If you can provide me more details please email me.
Friday, April 23, 2010
Post a Comment

Popular posts from this blog

OpenSubtitles.org // View topic - Oscar not downloading subtitles

For all users of the fabulous program OSCAR for downloading subtitles from opensubtitles.org there is a new API ddress located at: http://api.opensubtitles.org/xml-rpc You have to go in preferences and updte the address overwriting it with the new one OpenSubtitles.org // View topic - Oscar not downloading subtitles : "Go in preferences and make sure URL in OSDb is pointing to: http://api.opensubtitles.org/xml-rpc Looks like the API has changed address. Maybe someone should put a sticky post here?"
Read more