Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

Formula in the worksheet.

Formula result in the worksheet.

Say that you've written a list of headlines to be posted on your Web site, and they cannot be over 40 characters (letters, numbers, and spaces) long. To ensure that the character count is within that limit, you would type this formula in cell B1:

**=LEN(A1)**

The LEN function finds the number of characters in cell A1 and reports the result, which is 35.

The next step would be to copy the formula in cell B1 down the column to find the number of characters in the other cells. You'll have a chance to try this in the practice session at the end of the lesson.