Print Page - Excel help

Title: Excel help
Post by: Pete on July 23, 2006, 22:56:37 PM

I have a massive list of words (over 4,000 of em) like this:

(http://www.palmer934.plus.com/excelhelp.jpg)

Word : Value

Is there an easy way to delete the text from the cells leaving just the numbers, or to just sort them based on their numerical values?

Title: Re:Excel help
Post by: Beaker on July 23, 2006, 23:02:29 PM

you can sort on number, cant remember the option though and ive no Windows box here atm

Title: Excel help
Post by: Norphy on July 23, 2006, 23:51:05 PM

Save it as a text file and re-open using colons as seperators?

Title: Re:Excel help
Post by: Pete on July 23, 2006, 23:58:13 PM

Thankee :)

Title: Re:Excel help
Post by: mrt on July 25, 2006, 10:29:05 AM

You could do a find/replace with *: in the top box and blank in the bottom, it will then just leave the numbers

Tekforums

Chat => Entertainment & Technology => Topic started by: Pete on July 23, 2006, 22:56:37 PM