Filter Numbers and Text/Non-Numbers in Excel List
Formulas: =IF(ISNUMBER(A1),A1,””) =IF(ISTEXT(A1),A1,””) Sample Data Set: Sample Data List IsNumber? IsText? Test1 Test1 5884578457 5884578457 Text1 Text1 54545046 54545046 String1 String1 656893450 656893450 String1 String1 5.64768E+13 56476804932048 Sample data Excel Sheet: Excel-Filter-IsNumber-or-IsText.xlsx
Read more