Use LEN( ) to get the number of characters in text. Type =LEN(A2) in the field below to get the length of the text in cell A2.