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?

Separating text and data in a column
 

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
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?