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

Pin It on Pinterest

Share This