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
|