Prev: How do I look at two worksheets in one Excel workbook at same time
Next: Conditonal Format based on two different criteria
From: SJT on 5 Jun 2010 18:21 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" <SJT(a)discussions.microsoft.com> wrote in message > news:70B9153E-4351-4983-96D5-8870C6330D3D(a)microsoft.com... > >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 > > > |