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.

Use the LEN function and the MID function to count the number of characters in Excel

+ 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.

Use the LEN function and the MID function to count the number of characters in Excel

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.

Use the LEN function and the MID function to count the number of characters in Excel

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.

Use the LEN function and the MID function to count the number of characters in Excel

+ 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 =MID(A3;9;9)

Use the LEN function and the MID function to count the number of characters in Excel

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.

Use the LEN function and the MID function to count the number of characters in Excel

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.

Epilogue

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!

TECH NEWS RELATED

How to watch YouTube videos anonymously on Android phones

In this article, TechtipsNReview.com will introduce a new feature of Youtube that is to watch YouTube videos anonymously on Android phones. This is an extremely convenient thing that you can choose to use on your device. How to watch Youtube Videos offline without internet on Android phones, iPhones How to ...

View more: How to watch YouTube videos anonymously on Android phones

iPhone Keeps Disconnecting from WiFi: How to Fix?

If your iPhone Keeps Disconnecting from WiFi, you will have a hard time browsing, texting or getting anything else done on your device. iPhone Keeps Disconnecting from WiFi While users have reported the issue of WiFi Disconnecting from WiFi Network after an iOS update, this problem can occur at any ...

View more: iPhone Keeps Disconnecting from WiFi: How to Fix?

How to adjust the screen brightness of Android phones

To protect the user’s eyes, how to adjust the screen brightness of your Android phone is something you should do during the use of this device. Especially for low-light environments, adjusting the screen brightness appropriately will help you use the device longer and safer. Change screen brightness on Samsung Galaxy ...

View more: How to adjust the screen brightness of Android phones

Dead By Daylight x Fortnite crossover a possibility

Many are surprised to learn that Dead by Daylight may soon be doing a crossover with Fortnite.

View more: Dead By Daylight x Fortnite crossover a possibility

ApeCoin Gains 22% After Debut of Bored Ape-Themed Video With Eminem and Snoop Dogg

The bump signifies a minor recovery for the token, which recently shed over 65% of its value in a single month.

View more: ApeCoin Gains 22% After Debut of Bored Ape-Themed Video With Eminem and Snoop Dogg

iPhone hangs on apple: Causes and ways to fix it

If your iPhone hangs on the apple logo during startup or can’t load the home screen, you will be very worried. But maybe your phone isn’t broken yet. In the article below, Quantrimang will guide you how to fix errors when iPhone crashes. iPhone stuck with Apple logo The cause ...

View more: iPhone hangs on apple: Causes and ways to fix it

Instructions to bring the gesture navigation bar of OnePlus 6 to another Android phone

For those who love the OnePlus6 gesture navigation feature, we can completely apply it on our Android devices. And in this article, TechtipsNReview.com will guide you how to use and bring the gesture navigation bar of OnePlus 6 to the phone most easily. Bring iPhone X’s gesture navigation bar to ...

View more: Instructions to bring the gesture navigation bar of OnePlus 6 to another Android phone

Instructions on how to make video calls between Android phones

Instructions on how to make video calls between Android phones will be a way to help those who are using Samsung, HTC, Sony, Oppo devices…. which are popular today, can easily make video calls on their phones for free. fast and stable speed. Video calling, the best video calling app ...

View more: Instructions on how to make video calls between Android phones

Razer’s Huntsman Mini unclutters your desk, but it might not be suitable for everyone

Odd Inputs And Peculiar Peripherals: Chorded Keyset Recreates Engelbart’s Vision

How to create a bookmark save in Fire Emblem Warriors: Three Hopes

6 Best Ways to Fix Moisture Detected Error on Samsung Galaxy Phones

DVD Won’t Play On Windows 10? Try These 8 Best Fixes

How To Add An App To LG Smart TV? 5 Best Ways

Learn How To Stop Unwanted Robocalls And Texts Easily

Learn How Long Does iOS 15 Take To Download And Install

How To Take A Screenshot On Android Tablet? 5 Best Ways

How cooking works in Fire Emblem Warriors: Three Hopes

How to Share Your Live Location With Friends on Snapchat in 2022

Shindo Life Deva Ren Prime, Narumaki, Inferno, Ashen Storm update log and patch notes

OTHER TECH NEWS

Top Car News Car News