Question: how to create a formula in excel to count text?
Answer: Select the cell where you want the result to appear.
On the Formulas tab, click More Functions, point to Statistical, and then click one of the following functions: COUNTA: To count cells that are not empty. COUNT: To count cells that contain numbers. ... 
Select the range of cells that you want, and then press RETURN.