The Excel LEN function returns the length (number of characters) of a given text.
|1||Text||The text to return the number of characters of.|
Example: Simple Len formula
To use the LEN function, just insert a text that you want to count the characters of.
The Len function counts the number of characters in the Text column. The text Example text consists of 12 characters (space included). And SpreadsheetCenter.com consists of 21 characters in total.
Note: Numbers and Number Formatting
The Len function can be used to determine the number of characters in a number. Like so:
=LEN(123) = 3
Other characters that are used in numbers, like commas, periods or minus signs are also taken into account:
=LEN(-0.5) = 4
So the minus – and the period . are added to the total number of characters as well in this example. Something that’s not taken into account is number formatting, so for example:
The dollar sign $ and all other number formatting (commas and periods included) are not counted towards the total number of characters.
0, as you’d probably expect.
Yes, all spaces are counted. So that also includes any spaces before and after texts.