LEN

Get the number of characters in a string.

Syntax

LEN(text)

text

The string or cell you want the number of character for. For example: "Spreadsheets" or A3.

LEN(A1) returns 3, as there are three characters in car. Example 1