MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


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.