LEN () and LENB () functions in Excel

When you need to determine the length of a string while processing data in Excel, you cannot count each character individually because it will take a lot of time if the text string is long. The LEN () and LENB () functions will help you count the number of characters in a string.

LEN () and LENB () functions in Excel Picture 1

If you do not know how to use the LEN () and LENB () functions, you follow the article below.

The article describes the syntax and usage of the LEN () and LENB () functions in Excel.

Description

The LEN () function returns the number of characters in the input text string.

The LENB () function returns the number of bytes used to represent characters in the input text string. The LENB function only comes to 2 bytes per character when the default language is one of the languages that supports DBCS.

Syntax

= LEN (text)

= LENB (text)

Where: text is the input text string that you want to find its length, counting both spaces and required parameters.

For example

LEN ()

Count the number of characters of the string TipsMake.vn

= LEN ("TipsMake.vn")

LEN () and LENB () functions in Excel Picture 2

You can also refer to the text with a data box containing text for example: = LEN (B6)

LEN () and LENB () functions in Excel Picture 3

The LENB () function you use is similar to the LEN () function, but when using the LENB function, the default language of your computer and Office must be set as one of the languages that support DBCS. Otherwise LENB () will return the same result as LEN ().

Above is how to use the LEN () and LENB () functions to get better results, you can combine these two functions with some functions in Excel. Good luck!

Jessica Tanner

Update 19 May 2020

You should read it

May be interested

Logical functions (logical) in Excel
logical functions are used a lot during data processing in excel. the article summarizes the syntax and functions of functions in logical function groups in excel.
How to use Excel's VALUE function
excel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
Instructions for using Index function in Excel
index is a function that returns an array in excel. when using the index function, you get the values in a cell between the column and the row.
Tips for working with functions in Excel
functions that work with excel functions functions are predefined formulas for performing specific calculations, or for manipulating spreadsheets.
How to add computers to Excel
to perform complex calculations on excel or even change units, we can install computers on excel.
The MIN and MAX functions (the smallest and largest value functions) in Excel
the function to return the maximum value (max) and the function to return the minimum value (min) are two common statistical functions used by a lot of people in the process of manipulating and processing data in excel.
Common Excel functions you need to know about accounting
mastering the common excel functions helps accountants save time and effort compared to conventional manual calculations. today, software tips will list and guide readers on how to use some functions commonly used in accounting.
Differentiate between SUM, SUMIF, SUMIFS and DSUM functions
whenever you enter a function = sum in a cell in excel, you will get a lot of functions starting with sum and wondering how they are different? this article will help you solve that question.
Common calculation functions in Excel
excel is a spreadsheet that supports functions that help you in the process of calculating and processing data, if you know the calculation functions, how to use them, your work will be processed more quickly.
Basic functions in Excel, calculation formulas and illustrative examples
if you are new to spreadsheets, basic functions in excel such as sum, min, max, if will help you solve your work quickly and effectively. let's learn with free download now.