Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Non-numeric data accepted in statistical analyses

Posted by Rose on October 18, 2001 5:07 PM

I hope someone can help me. How do I get non-numeric data to be accepted in statistical tests? For instance, I have data that has '<' in them and I don't want to have to go through all my data (there is A LOT) and manually take these signs out. What can I do?

Sincerely,
Rose

Re: Non-numeric data accepted in statistical analyses

Posted by Travis on October 18, 2001 5:41 PM

If you just want to remove them, select the entire range, then edit>>find>>replace
finding the '<' and replacing with nothing.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.