EXCEL FUNCTIONS-LEN

INTRODUCTION

LEN function comes under the TEXT category in Excel.

LEN function returns the total number of characters in a string.

LEN can be used if we need to check any entry in a cell.

PURPOSE OF LEN FUNCTION IN EXCEL

LEN FUNCTION returns the number of characters in a given string.

PREREQUISITES TO LEARN LEN

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the financial terms is an advantage for the use of such formulas.
  •  Of course, Excel software.

Helpful links for the prerequisites mentioned above

What Excel does? How to use formula in Excel?

SYNTAX: LEN

The Syntax for the function is

=LEN(STRING)

STRING GIVEN TEXT

*SPACES ARE ALSO COUNTED AS CHARACTERS

EXAMPLE:LEN FUNCTION IN EXCEL

DATA SAMPLE

The string is “Once upon a time there was a king”

EXCEL:LEN FUNCTION EXAMPLE

STEPS TO USE LEN FUNCTION

H9, H11 AND H13 are containing some Text fragments.

The length output has been shown in the corresponding I column. The functions used are

LEN(H9), LEN(H11) and LEN(H13).

The output is 33,8 and 11.

*The spaces are counted as characters too.

CONFUSION CLARIFICATION

CHARACTERS INVOLVED WHILE COUNTING

LEN function counts characters of a string.

LEN function counts all the characters including the SPACES.

Always take care of the fact while making use of this function.