writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 40:
Line 40: − + − + + + + +
no edit summary
|}
|}
=LENB(A1) : Calculates the number of characters in a string referenced to cell A1. Displays '''7''' as the output. Character '#' is also counted.
=LENB(A1) : Calculates the number of characters in a string referenced to cell A1. <br>Displays '''7''' as the output. Character '#' is also counted.
=LENB(A3) : Calculates the number of characters in a string referenced to cell A3. Displays '''7''' as the output. Space and decimal point are also counted.
=LENB(A3) : Calculates the number of characters in a string referenced to cell A3. <br>Displays '''7''' as the output. Space and decimal point are also counted.
=LENB("<!#!>") : Displays '''5''' as the output.
=LENB("<!#!>") : Displays '''5''' as the output.
<font color ="Red">Need to give examples with characters/language supporting DBCS </font>
<font color ="Red">Need to give examples with characters/language supporting DBCS </font>
==Related Videos==
{{#ev:youtube|BI1otcs3nJE|280|center|LEN function}}
== See Also ==
== See Also ==