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:

=LEN(Cell Reference)

Getting length of a long string:

=LEN(“string”) (value needs to be kept within quotes)

 

A
1 Excel Bee
2
3 ExcelBee
4
5 =LEN(A1)
6
7 =LEN(A3)
8

Result in A5: 9

Result in A7: 8

Extra Tips: