View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default How to recognise a small letter as being different to a capital le

Boy, you guys are quick. I had to take a call and came back to find
all these answers. But I'll still throw my answer into the ring, on
the "more than one way to skin a cat" theory:
=SUMPRODUCT(--(ISNUMBER(FIND("h",A1:A10,1))))