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

SourceForge vs. Freshmeat | Tech FAQ Blog

SourceForge vs. Freshmeat | Tech FAQ Blog : "SourceForge vs. Freshmeat SourceForge and Freshmeat are both great web sites for finding obscure open source software packages. Both are very old and authoritative web sites; Freshmeat was started in March of 1998 and SourceForge came along in August of 1999. SourceForge has a larger database of projects to search, which is a major advantage. SourceForge also has a better search feature, in that you can filter your search results by meta data fields such as Development Status, License, and Programming Language. Unfortunately, once you find the list of projects which meet your criteria, SourceForge falls down. SourceForge presents very little data about each individial development project and the current SourceForge design makes it very difficult to find the real homepage of the development project. SourceForge is attempting to trap visitors within SourceForge’s limited environment. This makes SourceForge almost useless. Freshmeat do
Read more