How to Use the LEN Function Formula in Excel

 

A. Understanding the LEN function in Excel

textfunctionexcel.blogspot.com - Excel LEN formula is a text function ( functional text ) that is used to count the number of characters in a cell (including spaces). Syntax LEN is one of the fundamentals in computer intelligence ( computation intelligence ). Here's a tutorial on how to use the LEN formula in Excel.

B. How to Use the LEN Formula in Excel

The following is the systematics of writing the LEN formula in Microsoft Excel,

= LEN ( text )

• text  can be any text (string) that you type directly enclosed in quotation marks ("example")
• text  can be a cell reference that will be counted the number of characters

Using LEN with Direct Text

Example:

Calculated the number of characters from the sentence Advernesia Excel

= LEN ( "Excel Advernesia" )

So that we get the number of characters is 16 characters. bandarq online

Using LEN with Cell Reference

Example:

For example, you know the name of the person in the following table,

Steps

= LEN ( A2 )

Enter the above formula in the first row (A2), then autofill it to the last line you are looking for (A5).

Read : find-search-function-in-excel-excel