Geeks With Blogs
Prashant Acharya
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 Excel | Back to top

Comments on this post: Excel Last Index Of

# re: Excel Last Index Of
Requesting Gravatar...
Works Great! Thank you
Left by Atheeque on Sep 12, 2012 10:38 PM

Your comment:
 (will show your gravatar)

Copyright © prash | Powered by: