Len Formula finds the count of characters in a given value. Len formula is best used with other formulas like IF, Vlookup, Index, Match, etc. LEN Formula returns the number of characters in a text string. Syntax and process of how to use Len formula LEN(text) The xxx function syntax has the following arguments: Text Required. The text whose length you want to find. Spaces count as characters.