## How to use the LEN function

*Article updated on April 18, 2018*

The LEN function returns the number of characters in a cell value.

Formula in cell D3:

=LEN(B3)

Cell B7 contains a single space character, the LEN function accurately returns 1.

### Excel Function Syntax

LEN(*text*)

### Arguments

text |
Required. The text string or cell reference you want to count the number of characters in. |

### Comments

The LEN function does not count the number of characters in a formula, however, it counts the number of characters a formula displays.

### Articles with the 'LEN' Function

The following 9 articles have formulas that contain the LEN function.

Count how many times a string exists in a cell range (case insensitive)

Question: How do I count how many times a word exists in a range of cells? It does not have […]
Question: How do I count how many times a text string occurs in a cell in excel? Answer: Formula in […]

Question: How do I count the number of times a text string exists in a column? The text string may […]

The formula in cell B6 counts how many times the string (D3) is found in a cell value (B3) even […]

The array formula below counts how many times multiple text strings exist in a cell range. It is easy to […]

The array formula in cell C3:C7 extracts everything except numbers from cell B3. The following formula contains the TEXTJOIN function […]

Sometimes when you sort values you get unexpected results, the cause is probably unwanted characters in a cell. The same […]

Cell B3 contains a few odd characters and the formula in C3 shows the ANSI equivalent of each character in […]

The following array formula, demonstrated in cell C3, extracts all numbers from a cell value: =TEXTJOIN(, 1, TEXT(MID(B3, ROW($A$1:INDEX($A$1:$A$1000, LEN(B3))), […]

### Functions in 'Text'

The LEN function function is one of many functions in the 'Text' category.

The ASC function converts full-width (double-byte) characters to half-width (single-byte) characters. This function is for double-byte character set (DBCS) languages. […]

Use CHAR function to convert a number to the corresponding character. This is determined by your computers character set. Windows ANSI […]

The CLEAN function deletes nonprintable characters in a value, more specifically, it is designed to delete the first 32 nonprinting […]

The CODE function returns a specific number for the first character of the text argument, determined by your computers character set. […]

The CONCAT function concatenates values from multiple cells. There is, however, no delimiting character or a way to ignore empty […]

The EXACT function allows you to check if two values are precisely the same, it returns TRUE or FALSE. The […]

The FIND function returns the position of a specific string in another string, reading left to right. Note, the FIND function […]

The FIXED function rounds a number to the specified number of decimals, formats the number in decimal format using a […]

The LEFT function extracts a specific number of characters always starting from the left. Excel Function Syntax LEFT(text, [num_chars]) Arguments […]

The LEN function returns the number of characters in a cell value. Formula in cell D3: =LEN(B3) Cell B7 contains […]

The LOWER function converts a value to lower case letters. Formula in cell C3: =LOWER(B3) Excel Function Syntax LOWER(text) Arguments […]

The MID function returns a substring from a string based on the starting position and the number of characters you want […]

The RAND function calculates a random real number greater than or equal to 0 and less than 1. The function […]

The REPT function repeats a specific text a chosen number of times. Formula in cell D3: =REPT(B3,C3) Excel Function Syntax […]

The RIGHT function extracts a specific number of characters always starting from the right. Excel Function Syntax RIGHT(text,[num_chars]) Arguments text […]

Returns a number representing the position a substring is, if found in a textstring. FIND is case sensitive and SEARCH is not.

The SUBSTITUTE function replaces a specific text string in a value. Case sensitive. Formula in cell E3: =SUBSTITUTE(B3,C3,D3) Excel Function […]

The T function returns a text value if the argument is a text value. Formula in cell C3: =T(B3) The […]

Excel function syntax TEXT(value, format_text) Converts a value to text in a specific number format. Arguments value - The string […]

The TEXTJOIN function is a new function for office 365 subscribers, it is like the CONCATENATE function on steroids or what the CONCATENATE function […]

The picture above shows you values that have multiple leading and trailing blanks, sometimes also between words. The TRIM function […]

Converts a value to upper case letters. Formula in cell C3: =UPPER(B3) Excel Function Syntax UPPER(text) Arguments text Value to convert. Required. Share […]

Converts a text string that represents a number to a number. This function is included for compatibility with other software. […]