writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 41:
Line 41: − + − + − + − + − +
→Examples
|}
|}
=LEN(A1) : Calculates the number of characters in a string referenced to cell A1. Displays '''8''' as the output. Character '-' is also counted.
=LEN(A1) : Calculates the number of characters in a string referenced to cell A1. <br>Displays '''8''' as the output. Character '-' is also counted.
=LEN(A2) : Calculates the number of characters in a string referenced to cell A2. Displays '''12''' as the output. Space Character is also counted.
=LEN(A2) : Calculates the number of characters in a string referenced to cell A2. <br>Displays '''12''' as the output. Space Character is also counted.
=LEN(A3) : Calculates the number of characters in a string referenced to cell A3. Displays '''7''' as the output.
=LEN(A3) : Calculates the number of characters in a string referenced to cell A3. <br>Displays '''7''' as the output.
=LEN("<!#!>") :Displays '''5''' as the output.
=LEN("<!#!>") :Displays '''5''' as the output.
=LEN(A1&A2) : Adds the character length of two strings referenced to cells A1 and A2. Displays '''20''' as the output.
=LEN(A1&A2) : Adds the character length of two strings referenced to cells A1 and A2. <br>Displays '''20''' as the output.
=LEN(A3&"123") : Adds the character length of two strings referenced to cell A1 and "123". Displays '''10''' as the output.
=LEN(A3&"123") : Adds the character length of two strings referenced to cell A1 and "123". <br>Displays '''10''' as the output.
==Related Videos==
==Related Videos==