View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default Counting specific letters in a cell

How do I count the number of specific letters in a given cell? For example
if a cell has the words "Have a nice day!" I would only want to count only
the letter "a." Is there some sort of IF-LEN-combo function? Help.