How to get number of characters in cell Microsoft Excel / Use of LEN function (formula) in Microsoft Excel

LEN

Use of LEN function/formula in Microsoft Excel:

This formula/function helps to return the number of characters in a particular cell.

Formula:

The syntax of LEN function in Microsoft Excel is below.

=LEN(text)

Example :

Step 1: First type ADVANCEDMSEXCEL.BLOGSPOT.COM in cell B4 as per shown in below image.

Step 2: Type formula =LEN(B4) in cell B6 and press enter.

LEN