I have a list of phone numbers in excel, some of which are obviously duds because they contain repeating digits like this '5555555'. Is there any easy way of identifying these?
Its Excel 2010.
I have a list of phone numbers in excel, some of which are obviously duds because they contain repeating digits like this '5555555'. Is there any easy way of identifying these? Its Excel 2010. 


This formula will return TRUE if value in A1 repeats any digit 7 times in a row, FALSE otherwise
adjust as required, e.g. replace 7 by required number 

