LEN Function or LEN Formula in Excel with example

LEN Function or LEN Formula in Excel with example

LEN

Refers to Length. Len returns number of available characters (including white characters like space, soft enter etc.) in a specified text or string as number.

Syntax

=LEN(text)

Parameters

  • text: mandatory parameter as string, refers to text whose length to be returned.

Formula

Output

Next >> Understand OFFSET Function in Excel with example

Leave a Reply

Your email address will not be published.