What does it do?

Gives you the number of characters of the text

Formula breakdown:


What it means:

=LEN(text that you want to get the number of characters)

There are times when you need to get the number of characters within a cell in Excel.  Thankfully this is very easy to do with Excel’s LEN (Length) formula!

You can use the LEN function in Excel to count all characters in a cell, including letters, numbers, special characters, and all spaces.

The LEN function can be used as a data cleansing technique to find leading or trailing spaces or can be nested with other TEXT functions.

I explain how you can do this below:


STEP 1: We need to enter the LEN function next to the cell that we want to get the number of characters from:



STEP 2: The LEN arguments:


Which text do we want to get the number of characters from?

Reference the cell that contains the text string:



STEP 3: Do the same for the rest of the cells by dragging the LEN formula all the way down using the left mouse button.

Note that you are able to get the number of characters for each name. My name has 16 characters!


How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Total Bonus Due With An Array Lookup Formula The LOOKUP function has three arguments, it is a like a simplified VLOOKUP function: What does it do? It looks up a value (lookup_value) in one range (lookup_vector) and returns a value from the same position in a second range (result_vector) Formula breakdown: =LOOKU...
Return the Last Value in a Column with the Offset ... What does it do? It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cells Formula breakdown: =OFFSET(reference, rows, columns, , ) What it means: =OFFSET(start in this cell, go up/down a number of ro...
Autosum an Array of Data in Excel When you have an array of data in Excel with Totals at the bottom and to the right of the data, you can quickly fill in the Totals with the Autosum button. STEP 1: Highlight your data including the "Totals" row and column; STEP 2: Click the Autosum button (under the Home or...
Advanced SUMPRODUCT Function: Count You can use the SUMPRODUCT function to create advanced analysis of your data set.  For example, you can calculate the number of time a sales rep has made sales in a particular region.  Watch below to see how easy it is to create a count with this advanced SUMPRODUCT function. ...