=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