You guys are magicians!
Thanks again,
Emilio
"JE McGimpsey" wrote:
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,
|