Find Length of Characters In Excel 2010

With simple formula, you can find out the length of characters in text, sentence and in the table data instantly. Through Excel LEN function, you can check the length of characters your datasheet contains. LEN is a simple function, which requires only one argument to be provided with. This post will be putting some light over it.

Launch Excel 2010, and open a datasheet in which you want to know the length of data cells. For illustration purpose, we have included a datasheet, containing fields; Course, and Length which will contain character length of respective course titles. We want to calculate the length of characters, which makes up Course title. We will be adding a simple formula at location C2 in Length Column.

The syntax of the formula is;


We will fill the single argument of the formula with the location of the cell which contains text, rather than specifying text directly.

So the formula goes like;


Location B2 contains the text for which we want to know the character length. As you can see in the screen shot below, that it yield 20 as character length.

lengthcalculated Find Length of Characters In Excel 2010

Now you just need to drag the plus sign at the end of the cell towards the end of the column to find out the length of each course title.

length full

Now if you you want to exclusively check the length of characters of any word for any reason. You just need to give text as argument in double quotation mark.

=LEN(“Addictivetips We Review Software”)

It will yield 32 as length of characters in the sentence, as it also considers blank space as a character.

You can also check out previously reviewed Excel Functions; SUMIF, COUNTIF, VLOOKUP, HLOOKUP & PMT.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *