View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lee lee is offline
external usenet poster
 
Posts: 184
Default Count letter string, e.g. h/EL/p

I want to count how many times a string of letters occurs in each row in a
column. Column A has 1000 rows with 1 word in each row (1000 most frequent
English words). e.g. I would like to count how many words contain the string
of letters "ee" (sEEn).

I also want to count how frequent a string such as "A, any letter, E" (mAdE)
occurs.

Thanks

Lee