What does it do?

Gives you the number of characters of the text

Formula breakdown:

=LEN(text)

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:

DOWNLOAD EXCEL WORKBOOK

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

=LEN(

 

STEP 2: The LEN arguments:

text

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

Reference the cell that contains the text string:

=LEN(C9)

 

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!

HELPFUL RESOURCE:

oztraining_728x90

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

How to Convert Formulas to Values  Have you ever had a scenario where you write a formula and just want to show the value output only and get rid of the formula?Here is an example of a formula: Well I do not need the formula, bit I do want the last names only....hard copied!Fortu...
WEEKDAY function: Introduction The WEEKDAY function returns the day of the week corresponding to a date.  The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday).So if you want to find out on what day you were born, then the WEEKDAY function will remind you.DOWNLOAD WORKBOOKHelp...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function.The RPT function uses the vertical bar character | as the first argument: text and references the va...
Top Excel Formulas & Function Examples To Get... Below you will find many Excel formula examples for key functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, and many more.Click on any Excel formula link below and it will take you to the free e...