Thread: Find Function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default Find Function

A9 should read: A1
Micky


"מיכאל (מיקי) אבידן" wrote:

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