Excel Length of Formula
Excel LEN formula is used to get number of characters in a cell. The formula counts the number of characters in a cell including spaces and special characters. (Excluding apostrophe ( ‘ ) symbol if occurred as a first character in the cell)
Syntax And Examples:
Getting length of characters within a cell with cell reference:
Getting length of a long string:
=LEN(“string”) (value needs to be kept within quotes)
Result in A5: 9
Result in A7: 8
- Excel LEN function accepts only one cell or one value as an argument.
- It includes count of spaces but does not count apostrophe ( ‘ ) symbol if occurred as first character in a cell.