In the category self-taught Excel Today I would like to introduce and guide you how to use the LEN and MID functions to calculate the total number of characters in a paragraph. Then extracting the sub-character fields to the appropriate cells is the fastest and most convenient, instead of having to copy and count the number of characters manually like you used to do in the past.
OK, now let’s practice together. But before I start, I would like to remind you a little bit that, Excel will count alphanumeric characters and spaces and all English accents except characters like @, but some Vietnamese accents like question mark, self, hypotenuse, sharp, heavy mark will not be counted as characters.
Instructions for using the LEN function to count the total number of characters in Excel
+ Step 1: You open the Excel file containing the text that you need to count out. For example, I have an Excel file as shown below.
+ Step 2: Next, you select the appropriate cell (any blank cell) to output the total characters in the text.
Perform: You enter the formula =LEN and then open parentheses (
=LEN() => next click on the cell containing the paragraph to be counted and close parentheses as shown.
Note: When choosing to sum a long character field consisting of many cells combined as above, you click on the first cell in the row and column range to enter the formula as shown.
+ Step 3: Then press Enter to display the results. Yes, so the paragraph I need to count has a total of
109 characters okay.
How to extract subtext from text field with MID . function
+ Step 1: In the Excel file, select the appropriate cell to contain the character to be extracted => then enter the formula =MID and open parentheses (
=MID() then click on the text field. You use semicolons to break commands.
+ Step 2: Next, you count the number of characters from the beginning of the text to the first letter of the text field you want to enter and enter the number of characters there, use a semicolon to break the command and choose the number of characters to display in the text field. Your child’s school looks like this
Enter to complete.
For example, I take the word labor: From the first character to the word worker is 9, and the total character of the word worker is also 9, then I will have the following formula
OK, so I just showed you how to use two functions LEN and MID. Count the total number of characters in Excel and extract subtext fields easily and conveniently.
For short and simple statistics, you can use the usual typing method, but for long documents that require high accuracy, the two functions LEN and MIN are very useful, because of their high accuracy. as well as quick operation, it will greatly assist in your work.
Yes, that’s how I just gave you a very detailed guide how to use the LEN function and the MID function in Excel to count the number of characters in a piece of text.
Hopefully this article will be useful for you. Good luck !
CTV: Luong Trung – techtipsnreview
The article achieved: 5/5 stars – (There are 2 reviews)
Note: Was this article helpful to you? Don’t forget to rate the article, like and share it with your friends and family!