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



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?

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

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

Thankee

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