View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Count letter string, e.g. h/EL/p

On Mon, 3 Sep 2007 19:06:17 +0100, "Sandy Mann"
wrote:

The < operator is better but Ron has us both beaten hands down if the OP
only want to count words not multiple occurrences within words.
--
Regards,


For ease of formulating, I'd probably use a regular expression UDF if he wanted
multiple occurrences within words


--ron