Count number of characters in a range of cells
Many may be familiar with the common LEN Excel formula which will count the number of characters in a cell. You may also have cause to want to calculate the number of characters in a range of cells. For example, you may need to check which columns in a spreadsheet with many columns have entries.
In order to accomplish this task, you can use an array formula that combines the SUM formula with the LEN formula
Press CTRL + SHIFT + ENTER when entering an array formula like this.
When entering the formula, you need to press CTRL + SHIFT + ENTER. It's an array formula.