LEN worksheet function for Excel – Reference
The daily question >
Take a quiz >

LEN worksheet function for Excel – Reference

Released: May 5, 2022
Updated: February 29, 2024
By: Excel Effects
LEN worksheet function in Excel

The LEN worksheet function in Excel returns the number of characters in a text string.

LEN worksheet function

Here is the syntax of the LEN function.

Syntax

=LEN(reference)

Arguments

Reference – A text string or cell range.

Example(s)

Example 1
Example 1a - LEN function
This example uses the LEN function from a cell reference. Below is the result.
Example 1b - Results of the LEN worksheet function
As a result of the above LEN function, 9 is returned.
Example 2
Example 2 - Find the length of text directly
So, you can also type a text string directly into the function. Thus, LEN(“Standards”) will return 9.
Example 3
Example 3a - LEN worksheet function using a range
Also, you can find the lengths of a group of cells, in one function. So, in the above LEN function, we try to find the lengths of multiple cells. It should automatically show the length for every cell in that range of A3 to A23. See the results below.
Example 3b - Result of using a range to find lengths
Results of the LEN function using a cell range.

Excel functions  Reference home

Excel Effects home

Everything is everything

Want to see everything, well almost everything on Excel Effects?

Everything is everything

Ads and affiliates

Careerist

Education

How-to guides Charting Excel PowerPoint Quick tips Quiz Snapshots VBA Videos Google courses Python courses Question of the day Tech Tuesday

Chart library

Chart library  Area charts Bar charts Bubble charts Column charts Combo charts Donut charts Line charts Math charts Pie charts Scatter charts Sheet charts Special charts

Digital office

Excel Effects filing and organizational tools for your digital office needs.

Yearly calendar Monthly calendar Project schedule template Templates

The Donut Maker

The Donut Maker by Techronology

More stuff
Cartoon charts

 

Affiliate stuff – Move up and excel with Excel