detecting more than 1 dot in dot separated items

[naeemdotcom]

Hi All,
I have dot-separated items in Col A as this:
apple.orange

Now I want to find the items which have more than 1 dots in them as this:
apple..orange or
apple.orange.banana

Can anyone help in this?

Any help will be highly appreciated.

[samba_ravi]

=LEN(A1)-LEN(SUBSTITUTE(A1,".",""))>1
try the above formula

[shukla.ankur281190]

or

Try

=SUMPRODUCT((MID(A1,ROW($1:$86),1)=".")*1)>1

[samba_ravi]

=IF(ISERROR(SEARCH(".",A1,SEARCH(".",A1)+1)),"No","Yes")