Count # of Digits in a CEll

[hrayani]

Hello To All,

Is there any formula which can count the number of digits in a cell - whether the cell is a manually entered value or a formula result.

For Example

Cell Value = 568793
# of Digits Are (6)

Awaiting reply.

Best Regards,

Humayun Rayani

 

[repairman615]

Hello Humayun,

For unique digits try:

=IF(ISERR(FIND(0,A1,1))<>ISERR(FIND(0,B2,1)),0,)&IF(ISERR(FIND(1,A1,1))<>ISERR(FIND(1,B2,1)),1,)&IF(ISERR(FIND(2,A1,1))<>ISERR(FIND(2,B2,1)),2,)&IF(ISERR(FIND(3,A1,1))<>ISERR(FIND(3,B2,1)),3,)&IF(ISERR(FIND(4,A1,1))<>ISERR(FIND(4,B2,1)),4,)&IF(ISERR(FIND(5,A1,1))<>ISERR(FIND(5,B2,1)),5,)&IF(ISERR(FIND(6,A1,1))<>ISERR(FIND(6,B2,1)),6,)&IF(ISERR(FIND(7,A1,1))<>ISERR(FIND(7,B2,1)),7,)&IF(ISERR(FIND(8,A1,1))<>ISERR(FIND(8,B2,1)),8,)&IF(ISERR(FIND(9,A1,1))<>ISERR(FIND(9,B2,1)),9,)

This compares the values in cells A1 , B1

Also here is slightly modified Matching digits:

=IF(ISERR(FIND(0,A1,1)=FIND(0,B2,1)),,0)&IF(ISERR(FIND(1,A1,1)=FIND(1,B2,1)),,1)&IF(ISERR(FIND(2,A1,1)=FIND(2,B2,1)),,2)&IF(ISERR(FIND(3,A1,1)=FIND(3,B2,1)),,3)&IF(ISERR(FIND(4,A1,1)=FIND(4,B2,1)),,4)&IF(ISERR(FIND(5,A1,1)=FIND(5,B2,1)),,5)&IF(ISERR(FIND(6,A1,1)=FIND(6,B2,1)),,6)&IF(ISERR(FIND(7,A1,1)=FIND(7,B2,1)),,7)&IF(ISERR(FIND(8,A1,1)=FIND(8,B2,1)),,8)&IF(ISERR(FIND(9,A1,1)=FIND(9,B2,1)),,9)

 

[hrayani]

hello repairman615

just waite a few minutes - i will let you know shortly.

 

[hrayani]

This is for the UNIQUE DIGITS

This compares the values in cells A1 , B1

Dear repairman615 the formula contains values in B2 - not in B1
Just to let you know.

ITS WORKING PERFECT... THANKS

Now i am trying the Modified formula of matching digits

 

[repairman615]

This compares the values in cells A1 , B1

The correct cells are:
Cells A1, B2.

ITS WORKING PERFECT... THANKS

BINGO!


There is no real difference in the results, only a few less characters in the formula.

 

[hrayani]

brother Both are 100% OK

pls tell me should i use the modified formula for matching digits or the previous one?

 

[repairman615]

Use the last posted for Matching.

I am glad this has worked.

Until next time.

Regards,

 

[hrayani]

brother next time has just arrived

there are few more things i want to ask you
can i go ahead?

i hope i am not getting on your nerves

 

[repairman615]

Don't feel as such, I am here to help and I do enjoy learning new things and helping you.

Honestly, I have learned more about excel by helping others here than I would have on my own or asking questions here.

However, I do think that having many different questions in one thread would make it harder for others to find the solutions if they had similar questions. They see this threads title as "count digits" and do not know that within this is also unique digits, matching digits and missing digits.

I am only thinking of others, start another thread and I will offer all the help I can and would enjoy another challange.

Jeff

 

[hrayani]

thanks jeff

i guess you are right

i should have realised it before..

pls see my new thread - i am gonna post it in 2 minutes

THREAD > Repeated Digits in a CELL