That formula worked.Thankyou

"Dave Peterson" wrote:

Don't use delimited.

Use Fixed Width.

Then draw a line between each character.

But try that formula first.

Mike wrote:

One more thing, I have to many columns to individually input delimiters. How
do I go about seperating these numbers?

"Dave Peterson" wrote:

So if you had this in A1:A20:

7887
9078
0650
2222
3620
2389
6653
9583
7377
3391
7961
4067
2913
9477
5401
5365
1697
4048
9004
8613

You'd want to get an answer of 7?

If yes:
=SUM(LEN(A1:A20)-LEN(SUBSTITUTE(A1:A20,"2","")))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.




Mike wrote:

I need to count one number in a number sequence for cells a1:a20. Im trying
to count the number "2" in every cell, but every cell has 4 numbers. How do I
count only one of those numbers in every cell?

--

Dave Peterson


--

Dave Peterson