Count the Total Number of Characters in a Cell in Google Sheet

4 Parts:

Steps

Video: Count the Total Number of Characters in a Cell in Google Sheet

Questions and Answers

Comments

You're watching VisiHow. In this video, we're going to show you how to calculate the number of characters in a cell using Google Sheets. In this video, we have different domain names that we may wish to purchase. The domain names are in column "C".

1. 1
   Click the "D2" cell

   .

   

   Was this step helpful? Yes | No| I need help
2. 2
   Type "=len(C2)"

   .

   Alternatively, click the "C2" cell instead of typing "C2".

   

   Was this step helpful? Yes | No| I need help
3. 3
   Press "Enter"

   .

   Google Sheets will show you the length of the cell. "C2" is 21 characters long in this video.

   

   Was this step helpful? Yes | No| I need help
4. 4
   You can fill the cells down simply by double-clicking the lower right-hand corner of the "D2" cell

   .

   

   Was this step helpful? Yes | No| I need help
5. 5
   That was how to calculate the number of characters within a cell using Google Sheets

   .

   If you have any questions or comments, please leave them in the space below. Thanks again for watching VisiHow!

   Was this step helpful? Yes | No| I need help

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments