Thread: Find Function
View Single Post
  #3  
Old June 4th, 2010, 08:13 PM posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן
external usenet poster
 
Posts: 562
Default Find Function

In cell B1 try: =FIND("B",A9,2)
Micky


"SJT" wrote:

I would like to find the second occurence of a specific alphanumeric
character in a cell. For example, if cell A1 contains "BOBBY" what would be
the formula for finding the second occurence of the letter "B". Thank you
advance for your assistance. Greatly appreciated