LinkBack URL
About LinkBacks
=find("a",F3,3) will find where the letter 'a' occurs for the third time in cell F3 but how do you find the last place 'a' occurs in cell F3?
=find("a",F3,3) will find where the letter 'a' occurs for the third time in cell F3 but how do you find the last place 'a' occurs in cell F3?
Last edited by BRISBANEBOB; 02-23-2010 at 09:55 PM.
How about this
=SEARCH("^^",SUBSTITUTE(F3,"a","^^",LEN(F3)-LEN(SUBSTITUTE(F3,"a",""))))
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
OK, that is seriously spooky. It works beautifully, but how?
LEN(F3)-LEN(SUBSTITUTE(F3,"a","")) counts the number of "a"
SUBSTITUTE(F3,"a","^^"...... substitutes the nth occurrence of "a" (the occurrence is determined above)
=Search("^^".....finds where the last a was.
Amazing - thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks