How to use the LEN function in Excel
While manipulating and processing spreadsheets on Excel , for business needs you need to specify the length of the string. We can use the LEN function to get the fastest and most accurate result of the number of characters to define.
With the manual way of counting each character in Excel, you will only apply to Excel data tables with little data and only parameters. As for tables with lots of data, that approach is completely impossible, unusable and too time consuming. If so, we can use the LEN function in Excel to measure the length of any string in the table. This function will return the total number of correct characters of the string, including spaces. The following article of Network Administrator will guide you how to use the LEN function in Excel.
- These are the most basic functions in Excel that you need to understand
- Summary of expensive shortcuts in Microsoft Excel
The LEN function syntax in Excel is LEN (text) .
In which Text is a string of characters to count. The function will return the length of the string, including the space character .
Example 1:
For example, I will count the student name in cell B2 in the table below.
Step 1:
To measure the length of the string 'Phạm Hà Anh' we will enter the formula to calculate = LEN (B2) . Press Enter to execute the LEN function.
Step 2:
After that, the total number of characters in the string will be returned as shown below.
Note to the user , I change the text string with cell B2 because the character string is accented so Excel will not receive it. In case the character string is not accented, you can enter the text directly.
The result also returns as correct.
Example 2:
We will combine the LEN function with any function, such as taking the numerical value in the middle of the SV code column to include it in the Number column. This will use the MID function and the LEN function.
Step 1:
In the example table, at the beginning and end of the character in the SV code column will be the letter character. Proceed to cut the string from the 3rd position, and get the number of characters needed by taking the length of the string minus 4.
The formula in this case is = MID (C2, 3, LEN (C2) - 4) .
When pressing Enter the result will return the correct character in the middle as shown below. When dragging down the cells below to copy the formula will also have the same result.
Here's how to use the LEN function in Excel, the function that calculates the length of any string in the table, along with how to combine the LEN function with another function like the MID function in the lesson. Depending on the circumstances required by the data table, we use the LEN function, as well as matching with other functions accordingly.
I wish you all success!
You should read it
- Basic Excel functions that anyone must know
- How to use Excel's VALUE function
- How to fix the SUM function doesn't add up in Excel
- How to use Hlookup function on Excel
- Instructions on how to count words in cells in Excel
- How to use MID functions to get strings in Excel
- How to use COUNTIF function on Excel
- How to use the SUM function to calculate totals in Excel
- How to use the function to delete spaces in Excel
- How to count characters in Excel
- How to use the MOD function and QUOTIENT function in Excel
- How to use the kernel function (PRODUCT function) in Excel
Maybe you are interested
How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
Date functions in Excel, DAY, WEEKDAY, MONTH
How to use the SUMIF function in Excel to calculate the sum based on conditions
How to use the Round function in Excel to round numbers and process data
How to use Vlookup function in Excel to search and reference
How to use the FILTER function in Excel