You can use the following three methods to count characters in Google Sheets:
Method 1: Count Total Characters in Cell
=LEN(A2)
Method 2: Count Total Characters in Column
=SUMPRODUCT(LEN(A2:A11))
Method 3: Count Specific Characters in Cell
=LEN(A2)- LEN(SUBSTITUTE(UPPER(A2),"R",""))
The following examples show how to use each method with the following dataset in Google Sheets:
Example 1: Count Total Characters in Cell
We can use the following formula to count the total number of characters in cell A2:
=LEN(A2)
We can then copy and paste this formula down to each remaining cell in column A to count the total number of characters in each cell:
From the output we can see:
- The team “Mavericks” contains 9 total characters
- The team “Warriors” contains 8 total characters
- The team “Heat” contains 4 total characters
And so on.
Note: The LEN() function will also count any blank spaces in the cell.
Example 2: Count Total Characters in Column
We can use the following formula to count the total number of characters in the cell range A2:A11:
=SUMPRODUCT(LEN(A2:A11))
The following screenshot shows how to use this formula in practice:
From the output we can see that there are 63 total characters in column A.
Example 3: Count Specific Characters in Cell
We can use the following formula to count the total number of characters equal to “R” in cell A2:
=LEN(A2)- LEN(SUBSTITUTE(UPPER(A2),"R",""))
We can then copy and paste this formula down to each remaining cell in column A to count the total number of characters equal to “R” in each cell:
From the output we can see:
- There is 1 “R” character in cell A2.
- There are 3 “R” characters in cell A3.
- There are 0 “R” characters in cell A4.
And so on.
Additional Resources
The following tutorials explain how to perform other common operations in Google Sheets:
Google Sheets: How to Use COUNTIF From Another Sheet
Google Sheets: How to Use COUNTIF with Multiple Ranges
Google Sheets: How to Use COUNTIFS with a Date Range