Mis ultimas reseƱas de Peliculas

Sunday, March 07, 2010

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,"\",""))))

3 comments:

Anonymous said...

Amiable post and this fill someone in on helped me alot in my college assignement. Gratefulness you as your information.

Anonymous said...

Hello,

can anyone tell me which is the best counter strike guide ? :)...i found this one :

http://www.downloadzdb.com/Counter_Strike_Best_Guide

What do you believe harshly it ?

Thanx in advance

Sorry for my bad english :s

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.