# Cell character counting formula?

I need a formula that counts the total number of characters in a cell but also will count how many times that number of characters occurs.

For example in column A:

A range of 10 cells with 201, 202, 203, 204, 205, 1001, 1002, 1003, 1004, 1005.

There are 5 cells with 3 characters and 5 cells with 4 characters.

What would the formula be for this? Not sure how high I would need to go in terms of how many characters in each cell to count but I'm hoping that's an easy edit in the formula later on.

SNAP87 ask on

## 4 Answers Cell character counting formula?

For the number of chars, use another column with

`=len(cell)`

.Then make a dynamic table where you put the len column at the left side of the table and the len column again at the middle. Make sure the table is saying "count of len" or something very similar to this.

## Daniel Möller 4 months ago

With data in column

A, inB1enter:and copy downwards:

## Gary's Student 4 months ago

Add a helper column with the formula

`=len(A1)`

and copy that for column A. Then you can have a list of the different values 3,4,5... and`countif(B:B,C1)`

and that will give you the count of values with length 3.## JoeJam 4 months ago

## Cell Characters Count Array Version

## VBasic2008 4 months ago