Finding Length of Text
Excel LEN() function returns the length of a text string. It is often used with LEFT(), RIGHT() and MID() function to perform text manipulation. Together, these functions allow one to find a substring that is to the left or right of a certain character and so on.
Syntax of Excel LEN Function
LEN() function has the below syntax
=LEN(text)
where string can be a text string or be replaced with a cell address.
Note that a blank space is counted as one character, so is a tab character or a copyright symbol.
Using IF() with LEN()
IF() and LEN() together can be used to test if a cell contains an empty string. This is different from ISBLANK() function. For example, suppose you have a formula that would return a blank string in cell A1, the formula
=IF(LEN(A1)=0, TRUE, FALSE)
will return TRUE, whereas
=ISBLANK(A1)
will return FALSE.
Another use of the combo is to tell between standard numbers and international numbers using character length.
Related Post