Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to count the number of digits and/or characters in a cell and
return that number? Thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this:
A1 = 12345 =LEN(A1) Result = 5 Biff "Tonester" wrote in message ... Is there a way to count the number of digits and/or characters in a cell and return that number? Thanks |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks
that worked perfectly! "T. Valko" wrote: Try this: A1 = 12345 =LEN(A1) Result = 5 Biff "Tonester" wrote in message ... Is there a way to count the number of digits and/or characters in a cell and return that number? Thanks |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You're welcome. Thanks for the feedback!
Biff "Tonester" wrote in message ... Thanks that worked perfectly! "T. Valko" wrote: Try this: A1 = 12345 =LEN(A1) Result = 5 Biff "Tonester" wrote in message ... Is there a way to count the number of digits and/or characters in a cell and return that number? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting | Excel Worksheet Functions | |||
Counting help | Excel Discussion (Misc queries) | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting using 9-key pad | Excel Worksheet Functions | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |