Question: I want to extract all numeric values into a new column? Also all text values into another column?

Answer:

List all numbers in a column

Filter numbers into a new column
Array formula in C2:

=INDEX(List, SMALL(IF(ISNUMBER(List), ROW(List)-MIN(ROW(List))+1, ""), ROWS(C1:$C$1))) + CTRL + SHIFT + ENTER copied down as far as necessary.

Filter text into a new column
Array formula in D2:

=INDEX(List, SMALL(IF(ISTEXT(List), ROW(List)-MIN(ROW(List))+1, ""), ROWS(D1:$D$1))) + CTRL + SHIFT + ENTER copied down as far as necessary.

Named range
List (A2:A11)
What is named ranges?

How to implement array formula to your workbook
Change the named range. If your list starts at, for example, F3. Change C1:$C$1 (or D1:$D$1) in the above formulas to F2:$F$2.

Download excel sample file for this tutorial.
List all numbers in a column
(Excel 97-2003 Workbook *.xls)

Functions in this article:

IF(logical_test;[value_if:true];[value_if_false])
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

INDEX(array,row_num,[column_num])
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

SMALL(array,k) Returns the k-th smallest row number in this data set.

ISTEXT(value)
Checks whether a value is text, and returns TRUE or FALSE

ISNUMBER(value)
Checks whether a value is a number and returns TRUE or FALSE

MIN(number1,[number2])
Returns the smallest number in a set of values. Ignores logical values and text

ROWS(array) returns the number of rows in a reference or an array