Excel Functions and Formulas, LEN()

The LEN() function returns the number of characters in a text string.

Syntax:

=LEN(Text String)

Text String: The text string to return the number of characters of.


Example:

Lets say we want to receive the number of characters of the text string in cell A1:

Excel, Function Formulas,LEN Text in cell A1
The text string “Some Text” has 9 characters:

“S”, “o”, “m”, “e”, ” “, “T”, “e”, “x”, “t”

The number of characters can be obtained by writing the function below in cell B2:

=LEN(A1)

Excel, Function Formulas, LEN

Result:

Excel, Function Formulas,LEN Result

See also:

If you need assistance with your code, or you are looking to hire a VBA programmer feel free to contact me. Also please visit my website  www.software-solutions-online.com

Leave a Reply

Your email address will not be published. Required fields are marked *