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
> >
>
First  |  Prev  | 
Pages: 1 2
Prev: How do I look at two worksheets in one Excel workbook at same time
Next: Conditonal Format based on two different criteria