You can count the cells that contain only certain text or you can count cells that contain certain text inside of a longer string of characters. If you're using Google Sheets and you want to count the occurrences of a certain letter or word, there's a pretty easy function that you can use.Apr 11, 2012 · LEFT(text, number) text : A string. and is a string value. number: An optional argument specifying the desired length of the returned string. string-length is a number value and must be greater than or equal to 1. Notes. The count includes all spaces, numbers, and special characters. the formula in cell B1 is =LEFT(A1,5) When a range with both width and height greater than 1 is specified, cell values are appended across rows rather than down columns. That is, CONCATENATE(A2:B7) is equivalent to... Start studying Google Sheets Practice. Learn vocabulary, terms, and more with flashcards, games, and other study tools.