How to use Microsoft Excel LEN function to know length of text string

Len is an important function which is found in the Text function category. Len function returns the specified number of characters from the start of the text string. This guide helps all excel users to understand how to use Microsoft Excel LEN function to know length of text string.

During using LEN function, if you apply any kind of formatting on any string or number it’s not included in the total length. LEN function also include number of spaces in the given text string. For eg. If you put “505” in a cell and after applying formatting it shows like this “Rs.505.00”. Now LEN function shows 3 as a result.

Must Read: Use Data Validation and VLookup Function in MS Excel

LEN Function Definition and Syntax:

LEN function is used to return the number of characters within a given text string including spaces.  This function allows you to get the length the text.

Syntax : LEN(text)

Text: Any type of text string which length you want to find. If you have any spaces then they are also count as a characters.

How to use Microsoft Excel LEN function to know length of text string

Len is an important text function which is used to show the length of any string. Text string include all text, numbers and other format of data. This guide helps to how to use Microsoft Excel LEN function to know the length of any text string. You have to take few simple given steps which helps you to solve your problem, have a look.

How to use Microsoft Excel LEN function to know length of text string

Step 1: Type any text string or value in the cell which length you want to know.

Step 2: Take cursor on any cell in which you want to show the result. Now, type the following given Microsoft Excel LEN function to know length of text string. =LEN(A3) and press Enter.

Must Read: Conditional Formatting – How to generate chess board on excel

You can also use text string in double quotation mark at the place of cell address like this =LEN(“Amit 08877”) and press Enter to get the result.
We hope after reading this guide how to use Microsoft Excel LEN function to know length of text string help most of novice excel users to get the exact result. If you have any suggestion regarding this guide please write us in the comment box. Thanks to all.

Leave a Reply

Your email address will not be published. Required fields are marked *