Separating text and numeric

vaishali_12 

If you use 365, a formulae which filter text and numeric cells are

= FILTER(range, ISTEXT(range))

= FILTER(range, ISNUMBER(range))

Another tactic that could be useful is simply to sort the range, so placing numbers before text.

= SORT(range)