View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:

=(LEN(D5)-LEN(SUBSTITUTE(D5,"/",""))) =2

In article ,
Wind54Surfer wrote:

Hi everyone,

I believe now I am asking too much.

I use (as prescribed by this group)

=ISNUMBER(SEARCH("/",D5)) to find "/" in a cell.

I would like to extend this to find 2 or more instances (CM/F/CM), (F/F/F/)

Right now it does not differentiate if is 1 or more instances.

Is it possible?

Thanks for any help,