Returns the number of characters in a text string.

textThe text string you want to find the length of.

* This function will count how many characters there are in a text string.
* Any blank spaces are counted as individual characters.
* Number formatting is not included.
* Any trailing zeros are counted.
* This function returns the length of the displayed text or value and not the underlying value.
* You can use the LEFT function to return the first or left most characters in a text string.
* You can use the RIGHT function to return the last or right most characters in a text string.
* You can use the LENB function if you have languages that use the double-byte character set.
* The equivalent VBA function is VBA.LEN
* For the Microsoft documentation refer to support.microsoft.com

1=LEN("some text") = 920.00
2=LEN(" some text") = 1020.00
3=LEN("") = 010.00
4=LEN(20) = 210.00
5=LEN("123456789") = 910.00
6=LEN("00020") = 5=TODAY() = 01 May 2022
7=LEN("00020") = 5 
8=LEN(B1) = 2 
9=LEN(B2) = 5 
10=LEN(B6) = 5 

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top