Home How To How To Count Characters in Microsoft Excel

How To Count Characters in Microsoft Excel

by Geek Insider Staff

Unlike Microsoft Word, which has a tool to count characters in the document, Excel requires using the LEN function to get the character count. Here is the process.

How To Use The LEN Function To Count Characters In Excel. 

  1. Click the cell where you want to show the character count. 
  2. Type =LEN(cell). 

The “cell” represents the actual cell with the characters. So, if you want the character count of cell B1, you’d enter =LEN(B1).

Geek insider, geekinsider, geekinsider. Com,, how to count characters in microsoft excel, how to

3. Click on other spaces, and the character count will appear automatically. 

Geek insider, geekinsider, geekinsider. Com,, how to count characters in microsoft excel, how to

4. Alternatively, you can copy the entire content of cell B1.

5. Paste it in the formula 

=LEN(“How many characters are in this cell?”)

6. Be sure to put it in quotation marks, as shown below. 

Geek insider, geekinsider, geekinsider. Com,, how to count characters in microsoft excel, how to

You may also like

Leave a Comment