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

 

[Aladin Akyurek]

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

=LEN(A2)

for integers.

 

[repairman615]

Hello Humayun,

Always glad to hear from you, I think the LEN() function should do.

Try like:

=LEN(A1)

where A1 is the cell which you would like to count digits.

Best Regards,

 

[hrayani]

Dear Aladin Akyurek******** type=text/javascript> vbmenu_register("postmenu_2631991", true); *********>

Thanks dear... it was so easy yet i wasn't able to do it...

Thanks Anyway,

Dear Repairman615

You really are a dear friend...

Allah Bless U

Regards,

Humayun

 

[repairman615]

Humayun,
Were you able to use the formula as you would like?

Aladin provided a similar formula as I. When you said it did not work I was unsure if either solution worked for you.

Regards,

 

[hrayani]

Oh Yes,, it did worked perfect..

What i was trying to say is this formula is so easy that i should have knew it before...

Actually, english is not my mother or national language that is why i wasn't able to explain it properly... pls bear me..

Dear there is one more thing which i would like to ask you..

For Example cell A1 value = 564893
is there any formula which could show the missing digits like 0127 are missing in the above cell...

am I sounding illogical ???

 

[repairman615]

Try:

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

 

[hrayani]

Thanks Repairman615

Bingo

Worked PERFECT

 

[Sachin.Medhe]

Try given formula in one cell & need to put the value in cell C6 !

=IF(ISERROR(FIND("1",C6,1))=TRUE,1,"")&IF(ISERROR(FIND("2",C6,1))=TRUE,",2","")&IF(ISERROR(FIND("3",C6,1))=TRUE,",3","")&IF(ISERROR(FIND("4",C6,1))=TRUE,",4","")&IF(ISERROR(FIND("5",C6,1))=TRUE,",5","")&IF(ISERROR(FIND("6",C6,1))=TRUE,",6","")&IF(ISERROR(FIND("7",C6,1))=TRUE,",7","")&IF(ISERROR(FIND("8",C6,1))=TRUE,",8","")&IF(ISERROR(FIND("9",C6,1))=TRUE,",9","")&IF(ISERROR(FIND("0",C6,1))=TRUE,",0","")

 

[hrayani]

Dear Repairman615

there are few more formulas about which i am sure you will would help me..

Cell A1= 12589
Cell B2= 12679

Matching Digits in A1 & B1 = 129
Unique Digits are 5678

Any formulas for both of the above mentioned criteria ?