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:
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)
Result:
See also:
- Excel Functions and Formulas, Sample #1, Split String Based on Delimiter.
- Excel Functions and Formulas Tutorial / Sample, Text and String #2 (Advanced)
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