Page 11 of 23PREVNEXT

Use formulas to edit, correct, and proofread text

Using LEN function to count characters

Callout 1 Formula in the worksheet.
Callout 2 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:


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.

Page 11 of 23PREVNEXT