Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT CELL DIGITS
I have an array of account numbers (all numeric) from cell B1 to B56562. The
account numbers are required to be 14digits, some are less or more, I want to be able to determine, those that require correction, so as to address it. I am using Microsoft office 2003 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT CELL DIGITS
Insert a blank column to the left of the column containing the account #'s
and enter the following formula: =LEN(A1) Copy the formula for the length of the column containing your account #'s. The formula assumes that the starting account # is in cell A1 -- Kevin Backmann "Lawal" wrote: I have an array of account numbers (all numeric) from cell B1 to B56562. The account numbers are required to be 14digits, some are less or more, I want to be able to determine, those that require correction, so as to address it. I am using Microsoft office 2003 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT CELL DIGITS
Use LEN():
if B1 contains 12345678901234 then =LEN(B1) will return 14. Any cells that need correctly will not return 14. Paste this formula in an unused column and sort by this new column. -- Gary's Student "Lawal" wrote: I have an array of account numbers (all numeric) from cell B1 to B56562. The account numbers are required to be 14digits, some are less or more, I want to be able to determine, those that require correction, so as to address it. I am using Microsoft office 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to keep a count of the times a cell is changed | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) |