Google Sheets LEN Function

This post will guide you how to use Google Sheets LEN function with syntax and examples.

Description


The Google Sheets LEN function returns the length of a text string (the number of characters in a text string).

The LEN function can be used to count the number of characters for a given text string in google sheets. It also can count characters in numbers, but it will not count the number formatting.

The LEN function is a build-in function in Google Sheets and it is categorized as a Text Function.

Syntax


The syntax of the LEN function is as below:

= LEN(text)

Where the LEN function arguments are:

  • Text -This is a required argument. The text string that you want to get the length of.

Note: 

  • The LEN function only takes one argument. It counts the number of characters in text string, including space or non-printing characters. If the LEN function returns unexpected values, and you need to make sure that there are no such characters in given text string.
  • If text string is an empty string or cell reference to an empty cell, the LEN function returns
  • Len function will also count the characters in numeric value 

Google Sheets LEN Function Examples


The below examples will show you how to use google sheets LEN Text function to get the length of a text string.

#1 To get the number of characters in the B1 cell, just using formula: 

=LEN(B1)

Google sheets len function1

#2 To get the Length of the text string in B2 Cell, just using formula:

=LEN(B2)

Google sheets len function1

#3 Using LEN function to count the number of characters in a text string:

=LEN(“google”)   //it returns 6

Google sheets len function1

#4 count the number of characters in a text string in which contain a space character:

=LEN(“google      “)  //it returns 9

Google sheets len function1

The LEN function can be used with the LEFT function and FIND function to extract a substring text to the left of a given text string .

Related Functions


  • Google Sheets FIND Function
    The Google Sheets FIND function returns the position of the first text string (sub string) within another text string.The syntax of the FIND function is as below:= FIND(find_text, within_text,[start_num]) …
  • Google Sheets LEFT Function
    returns a substring (a specified number of the characters) from a text string, starting from the leftmost character. The syntax of the LEFT function is as below:= LEFT(text,[num_chars]) …

 

 

 

 

Related Posts

Google Sheets: Sort by Second or Third character

This article will talk about how to sort by the second or third character in a cell's string value in google sheets. You may want to sort the values of strings by the second or last character from the cells ...

Google Sheets LN Function

This post will guide you how to use Google Sheets LN function with syntax and examples. Description The Google Sheets LN function returns the natural logarithm of a given number.  And the natural logarithms are based on the constant e ...

Google Sheets DEGREES Function

This post will guide you how to use Google Sheets DEGREES function with syntax and examples. Description The Google Sheets DEGREES function converts radians into degrees. And it will return a numeric value. For examples, if you pass the PI() function into ...

Google Sheets COSH Function

This post will guide you how to use Google Sheets COSH function with syntax and examples. Description The Google Sheets COSH function returns the hyperbolic cosine of a given angle. The purpose of this function is used to get hyperbolic ...

Google Sheets COS Function

This post will guide you how to use Google Sheets COS function with syntax and examples. Description The Google Sheets COS function returns the cosine of a given angle. If you want to supply an angle to COS function in ...

Sidebar