my work, the Baha'i Faith and football - simply put, my life!
Tuesday, October 23, 2012
excel: last index of
assuming that text is in cell A1, and we are looking for "\" character, this works: =SEARCH("@",SUBSTITUTE(A1,"\","@",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))
No comments:
Post a Comment