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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove or exclude Text from cells, just leave numbers in Excel 1
Excel does not accept text format! 0
Cell data entering slow! 0
Finding the proper style field and the numbered paragraph value within the style 0
Macro to Select text from a point given to a specific word 2
How can the font and size of (all) citation numbers be altered? 1
WORD VBA Search and switch to advanced ... 1
Finding the right style field in VBA 0

Top