For example cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1. Excel will complete the function. Excel allows you to manipulate the data using formulas andor functions.
For example to count the number of occurrences of a string of text or a number within a range of cells use the COUNTIF function.
To use the function enter LENcell in the formula bar and press EnterIn these examples cell is the cell you want to count such as B1. For example the most used function in Excel is the SUM function which is used to add together. The tutorial provides a list of Excel basic formulas and functions with examples and links to related in-depth tutorials. Excel String Text Functions.