Geeks With Blogs
Prashant Acharya November 2011 Entries
Excel Last Index Of
It is challenging sometimes to find last occurrence of a character in a string. I hope the following formula can help: =SEARCH("@",SUBSTITUTE(A1,"\","@",LEN(A1)-LEN(SUBSTITUTE(A1,"\","")))) * Considering that the Text is in cell A1, and we are looking for "\" character.

Posted On Wednesday, November 2, 2011 1:08 PM

Copyright © prash | Powered by: GeeksWithBlogs.net