Separating text and data in a column

I have a column that contains text and data, never in the same cells, but I
want to separate the numbers from the text in order to do a total at the
bottom. Is there a formula for this?

Amber

Assume text is text and data is numeric, just SUM the column. Excel will ignore
the text.

=SUM(A:A) entered in B1 should give you the total of any numbers in column A..


Gord Dibben MS Excel MVP

On Tue, 4 Apr 2006 14:36:02 -0700, Amber <[email protected]>
wrote:

>I have a column that contains text and data, never in the same cells, but I
>want to separate the numbers from the text in order to do a total at the
>bottom. Is there a formula for this?