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

Answer:

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

Related posts:

1. Create a unique distinct sorted list containing both numbers text removing blanks in excel
2. Create a unique distinct text list from a range containing both numerical and text values in excel
3. Extract numbers and text from a range using array formula in excel
4. Create unique distinct list sorted based on text length using array formula in excel
5. Identify largest text value in a column using array formula in excel
6. Filter a column and create a new unique list sorted from A to Z using array formula in excel
7. Text to be on top of column in excel
8. Sort text values by length using array formula in excel
9. Extract all rows from a range that meet criteria in one column in excel
10. Extract duplicate text values from a range containing both numerical and text values in excel