Search Substring for data that shouldn't be on Spreadsheet

[Chris Waller]

Hi, I am trying to come up with an easy way in Excel 2010 to search column F for data that should not be there. Column F contains a string of data which contains a number. This number refers to the Job that has been undertaken, for Example A3 - 1G 123456 Data String. I know that the number 123456 (Always a six digit number) is correct whereas if the number was anything other than this, then that would be incorrect. There are anything from one line of data to many hundreds and I need an easy way to identify the incorrect ones. Thanks in advance.

 

[Chris Waller]

Rick,

Just had a look at your formula and it appears to do the trick. Brilliant. Thanks again for your help.