Is there any way to find whether excel workbook has any 8 digit number. E.g. 12345678,112233144 etc. could be in entire column or within in a statement on any of the tab of excel workbook. I need excel to find out any number(if any) in excel workbook. examples of 8 digit number could be present in excel file are:
12341235
43214327
22331221 all in a column. Could be in text or number format(without comma ",")
or number could be mentioned within a statement. e.g.
I went to his house no. 11124432 but he was not there
Cell/Column/Tab within excel workbook is not fixed where 8 digit number could be mentioned, so 8 digit number need to be searched in every cell of Excel file, like we use Ctrl+F. I hope I was able to provide exact requirement and the scenario. If I missed any information that is required to reach a solution then please let me know. Looking for your advise, thanks!
12341235
43214327
22331221 all in a column. Could be in text or number format(without comma ",")
or number could be mentioned within a statement. e.g.
I went to his house no. 11124432 but he was not there
Cell/Column/Tab within excel workbook is not fixed where 8 digit number could be mentioned, so 8 digit number need to be searched in every cell of Excel file, like we use Ctrl+F. I hope I was able to provide exact requirement and the scenario. If I missed any information that is required to reach a solution then please let me know. Looking for your advise, thanks!