Description
LEN is a text function in Excel. It returns number of characters or length of a text string. LEN returns length of a number or date without considering formatting. It count space as a character
Syntax
LEN(text)
Example
- LEN Excel function returns the number of characters in a text string
- LEN Excel function also count space as a character
- LEN Excel function returns length of number also
- LEN Excel function ignores the formatting while returning length, here it ignored the comma and trailing 0 as the number is in comma format
- Excel stores the date as number, in this case it’s 43913; hence, LEN returns 5 ignoring date formatting
0 Comments