If you have ever desired to try and come across the range of people in a line of textual content, you can use Microsoft Excel to do so, thanks to the LEN operate. Here’s how to use it.
What Is the LEN Functionality?
The LEN purpose is a easy calculation function that counts all the figures in a given textual content string, together with quantities, letters, specific characters, and spaces. The function name (LEN) is shorthand for size, as the perform output presents the overall duration of a text string as a quantity.
To give you an case in point, let us assume that an Excel workbook has a mobile with the following textual content:
This is an illustration text string that contains 56 figures!
The textual content string contains spaces, textual content, figures, and a special character, and has a duration of 56 figures. Should you would like to validate this calculation, you could use LEN to do so.
How to Use the LEN Purpose in Microsoft Excel
In contrast to other Excel features, the LEN perform is exceptionally easy to use. It includes only just one argument—the text string that you want to estimate. You can either put this in the formulation directly, or you can refer to a cell that is made up of the textual content string.
For illustration, the subsequent components calculates the length of a textual content string contained in mobile A1. If you would like to use this system on your own, swap the mobile reference with your own.
=LEN(A1)
As beforehand outlined, you can also use LEN to estimate the duration of a textual content string written into the formula immediately using the illustration system underneath.
=LEN("This is an example textual content string.")
You can swap the case in point textual content with your personal, but you’ll have to have to encompass the textual content string in estimate marks. Alternatively, location the textual content in a independent mobile (without quotation marks), then use the mobile reference for that cell in your components to identify the length as an alternative.
Connected: Valuable Features You Must Get to Know