COUNT CELL DIGITS

L

Lawal

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
 
K

Kevin B

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
 
G

Gary''s Student

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.
 
Top