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:
