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