Exculde Text from cells

S

slagg7575

Hi all!

I have a range of cells with numbers and text in them, IE, 50mg, 100mg
OID, 200md TID
How do I do the averages, counts, sums,of these numbers while exculding
the text part of the cell? I just want the numbers to be calculated.

Thanks in Advance,
 
Top