Thread: Find Function
View Single Post
  #6  
Old June 5th, 2010, 11:21 PM posted to microsoft.public.excel.misc
SJT
external usenet poster
 
Posts: 86
Default Find Function

Thank you Niek.

"Niek Otten" wrote:

=FIND("#",SUBSTITUTE(A1,"B","#",2))

Replace # by another symbol if it can be part of your text

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"SJT" wrote in message
...
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