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 NETWORKDAYS Function
google sheets networkdays function1

This post will guide you how to use Google Sheets NETWORKDAYS function with syntax and examples. Description The Google Sheets NETWORKDAYS function returns the number of net working days between tow given days. The NETWORKDAYS function can be used to ...

Google Sheets MONTH Function
google sheets month function1

This post will guide you how to use Google Sheets MONTH function with syntax and examples. Description The Google Sheets MONTH function returns the month of a date represented by a serial number. And the month is an integer number ...

Google Sheets MINUTE Function
google sheets minute function1

This post will guide you how to use Google Sheets MINUTE function with syntax and examples. Description The Google Sheets MINUTE returns the minutes of a time value. And the minutes is an integer number from 0 to 59. So ...

Google Sheets ISOWEEKNUM Function
google sheets isoweeknum function1

This post will guide you how to use Google Sheets ISOWEEKNUM function with syntax and examples. Description The Google Sheets ISOWEEKNUM returns the number of the ISO week of the year for a given date. ISO weeks begin on Monday ...

Google Sheets HOUR Function
google sheets hour function1

This post will guide you how to use Google Sheets HOUR function with syntax and examples. Description The Google Sheets HOUR returns the hour of a time value. Or returns an integer value that represent the hour component of a ...

Google Sheets EOMONTH Function
google sheets eomonth function1

This post will guide you how to use Google Sheets EOMONTH function with syntax and examples. Description The Google Sheets EOMONTH returns a date representing the last day of the month, n months in the future or past. The EOMONTH ...

Google Sheets EDATE Function
google sheets edate function1

This post will guide you how to use Google Sheets EDATE function with syntax and examples. Description The Google Sheets EDATE returns a date that is a specified number of months before or after a specified date. You can use ...

Google Sheets DAYS360 Function
google sheets days360 function1

This post will guide you how to use Google Sheets DAYS360 function with syntax and examples. Description The Google Sheets DAYS360 will calculate the number of days between two dates based on a 360-day year. The DAYS360 function can be ...

Google Sheets DAYS Function
google sheets days function1

This post will guide you how to use Google Sheets DAYS function with syntax and examples. Description The Google Sheets DAYS  returns the number of days between two dates. The DAYS function can be used to get the number of ...

Google Sheets DAY Function
google sheets day function1

This post will guide you how to use Google Sheets DAY function with syntax and examples. Description The Google Sheets DAY returns a day of a date (from 1 to 31). You can use the DAY function to extract a ...

Sidebar