I need a formula that counts both the total amount of characters in a cell and the frequency with which those characters appear.

For instance, in column A

201, 202, 203, 204, 205, 1001, 1002, 1003, 1004, and 1005 are the numbers in a set of ten cells.

Five cells have three characters, while five cells have four. What would the answer to this be? I'm not sure how many characters in each cell I would need to count, but I'm thinking that will be a simple formula edit in the future.
Nov 21, 2022 in Others 289 views

## 1 answer to this question.

With data in column A, in B1 enter:

```=SUMPRODUCT(--(LEN(A:A)=ROW()))
```

Then copy downwards:

I hope this helps you.

• 63,700 points

## Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...READ MORE

## What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

## How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

## MS Excel showing the formula in a cell instead of the resulting value

Make sure that... There's an = sign before the formula There's ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE