LENB

Formulas / LENB
Calculate the length of text.
=LENB(text)
  • text - the text to find the length of

Examples

  • =LEN("apple")

    The function returns the number of characters in a string. For example, this returns 5 because the string "apple" has five characters.

  • =LEN("apple ")

    The function also counts spaces when determining the length of a string. For example, this returns 6 because the string "apple " has six characters.

  • =RIGHT(A1,LEN(A1)-FIND(char,A1))

    The function can be used in combination with other Sourcetable functions. For example, this returns the text to the right of the character "A" in the string "apple" and returns the text "APPLE".


Summary

The LENB function is used to calculate the number of bytes used to store characters in a string. It is a useful tool for determining the size of a string, allowing for more efficient data storage.

  • The LENB function takes an argument, text, which is required.
  • The LENB function counts characters in numbers and can work with numbers.

Frequently Asked Questions

What is the LENB function?
The LENB function is a Sourcetable function that counts the number of characters in a string.
How does LENB function count characters?
The LENB function counts 1 byte per character when the default language is DBCS.
Does the LEN function count spaces as characters?
Yes, the LEN function counts spaces as characters.
What is the difference between the LEN and LENB functions?
  • The LEN function counts the number of characters in a string.
  • The LENB function counts 1 byte per character when the default language is DBCS.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV