2. Enter the formula "=len ()" in cell B 1. This function is used to count the number of characters.
3. Enter the cell name to be counted in the len () parameter, where the number of characters in the A2 cell is counted, so enter "A2", and the formula at this time is "=len(A2)".
4. If we want users to write only 100 words, then display the number of words that can be entered in B2. Then modify the formula to "= 100-LEN(A2)".
5. Of course, the above steps can show the number of characters that can be entered, but the text expression is not clear enough, so we have to modify the formula and add the necessary text description to make the formula express more clearly. The completed formula is: = "You can also enter"&; (100-LEN(A2) and amp "characters").
6. Click the "√" button in the formula editing bar after confirming the formula input.
7. In this way, the formula can show complete meaning.