On 2002-11-01 02:22, bigcahoonerburger wrote:
I want to assign a numerical value to each name in a list of names to allow excel to sort them. Is this possible.I get the feeling it might be v. easy but I haven't the faintest.Heres hoping someone can help and I don't look to foolish
To assign a numerical value to a name you just have to Concatenate, for example:
=7&"John Doe"
and you'll get:
7John Doe
You can add a column A, fill it with numbers and assuming that your names are from B2, put in C2:
=A2&B2
and copy to the last record.
Then copy column C and Paste Special it on Values.
Eli
This message was edited by eliW on 2002-11-01 03:44