Count Nr. Characters Formula?

[audrey]

Hello,

I have such numbers listed on a column, and I would like to know how many characthers are used, can you help me which formula I should use ?

Example.

120 = 3
120.01 = 6


<table border="0" cellpadding="0" cellspacing="0" width="64"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt; width: 48pt;" width="64" height="15">102.01.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.01.02</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.01.03</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.01.04</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.01.05</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.01.06</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.01.07</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.01.08</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.02</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.02.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.02.02</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.02.03</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.02.04</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.02.05</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.02.06</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.02.07</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.03</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.03.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.03.02</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.03.03</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.03.04</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.03.05</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.03.06</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">102.03.07</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.01.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.01.02</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.01.03</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.01.04</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.02</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.02.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.02.02</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.02.03</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.02.04</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.03</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.03.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.03.02</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.03.03</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">103.03.04</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">108</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">110</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">111</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">111.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">111.01.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">112</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">118</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">119</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">120</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">120.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">120.01.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">120.02</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">120.02.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">120.02.02</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">120.03</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">120.03.01</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">120.03.02</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">121</td> </tr> </tbody></table>

 

[VoG]

Try

=LEN(A1)

 

[Andrew Poulsom]

Like this?

=LEN(A1)

 

[audrey]

works perfect, thank you guys

 

[energman58]

Len(a1)