Extracting only the balance amount in a column with textnumber and number

[learner1excel]

So the column has a mixture of this: row 1 has textnumber and row two has only number. This column has thousands of rows with formats like row 1 and row 2.

Text123456

350.50

I only want to extract the 350.50 to another column so I can get a sum and do that for the whole column.

Can I get some help?

 

[JoeMo]

The SUM function will ignore text and sum only the numeric cells:

Excel Workbook
	D	E
1		Hdr
2		Text123
3		123
4		Text124
5		124
6		Text125
7		125
8		Text126
9		126
10		Text127
11		127
12		Text128
13		128
14		Text129
15		129
16		Text130
17	sum:	882
Sheet1

 

[brownbread]

If the existing data is in column A, starting on row 1, enter this formula in B1 and copy it down:
=IF(ISNUMBER(A1),A1,0)