Thread: Find Function
View Single Post
  #4  
Old June 4th, 2010, 08:14 PM posted to microsoft.public.excel.misc
Luke M[_4_]
external usenet poster
 
Posts: 451
Default Find Function

=FIND("B",SUBSTITUTE(A1,"B",CHAR(160),1))

Note that CHAR(160) is simply a non-printable character rarely used in
normal usage. The formula replaces the first instance of desired letter, and
then finds the 2nd instance. Alternatively:

=FIND(CHAR(160),SUBSTITUTE(A1,"B",CHAR(160),2))

Could be used, if you want to control which instance of the letter to find
(by simply changing the last arguement)

--
Best Regards,

Luke M
"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