Name
LEN
Synopsis
Use LEN to determine the number of characters in a string of text.
To Calculate
=LEN(Text
)
Example
Figure 18-5 shows how LEN determines the actual number of characters in a string.
Character Count
Keep in mind that spaces between words are also counted as characters in the string.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.