Need a formula to count the number of digits in a number.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I like to know how we can count the number of digits in a whole number...e.g. 243593 should return with 6...and so on

Also how can we now seperate this digits so they can be arranged like one per cell in the same sequence

In the above case how can I seperate the number so that A2=2, B2=4, C2=3, D2=5, E2=9 and F2=3

Help highly appriciated

Thanks.
 
Hi Jethwa,

You can use the LEN function:

=LEN(A1)

To separate the individual digits, use Data>Text to
columns. Select the fixed width option and set the break
lines for each digit.

Biff
-----Original Message-----
I like to know how we can count the number of digits in a
Click to expand...
whole number...e.g. 243593 should return with 6...and so
on.
Also how can we now seperate this digits so they can be
Click to expand...
arranged like one per cell in the same sequence.
In the above case how can I seperate the number so that
Click to expand...
A2=2, B2=4, C2=3, D2=5, E2=9 and F2=3.
 
Great.......... thanks a lot. I couln't believe how simple it was.

Now one more thing.....I created a macro to do the complete sequence and the numbers come up in individual columns.
Can we create a formula that would initiate a Macro. e.g. If B1=1 then run the Macro . If B2=0 Do not run the Macro.

Thanks

----- Biff wrote: -----

Hi Jethwa,

You can use the LEN function:

=LEN(A1)

To separate the individual digits, use Data>Text to
columns. Select the fixed width option and set the break
lines for each digit.

Biff
-----Original Message-----
I like to know how we can count the number of digits in a
Click to expand...
whole number...e.g. 243593 should return with 6...and so
on.
 
Back
Top