writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 45:
Line 45: − + − +
no edit summary
=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. Displays '''7''' as the output.
=LEN("<!#!>") :Displays '''5''' as the output.
=LEN("<!#!>") :Displays '''5''' as the output.
=LEN(A1&A2) : Adds the count 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. Displays '''20''' as the output.
=LEN(A3&"123") : Adds the count 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". Displays '''10''' as the output.
== See Also ==
== See Also ==