Characters contained in a cell

D

DHallgren

I have a list of several thousand vehicle identification numbers, and need to
verify that they all have 17 characters. Is there a way to use conditional
formatting to highlight any that have more or less than 17? Other Options?

Thanks for any help you can offer.
 
J

John

select the column or cells then data>validation>cell length equal to 17.
Then on the formula auditing toolbar click circle invalid data.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
T

Toppers

highlight colum (A in example)
CF=>Formula is:

=AND(NOT(ISBLANK(A1)),LEN(A1)<>17)

select colour

OK
 
Top