Tuesday, May 21, 2013

yogi_Count Number of A Specified Character In A Cell Or A Collection Of Cells

                                          Google Spreadsheet   Post  #1205
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 21, 2013
user Dyego Vanconcelos (http://productforums.google.com/forum/?zx=ttx1g8rgpf8v#!category-topic/docs/spreadsheets/jlimB7Ss15M)
How many times certain letter appears in a cell

Once I have a sheet with a cell containing the following text: "The book is green"

How do I know how many times the letter "e" appears?

The result should be 3.

here we go