names

[bigcahoonerburger]

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

 

[eliW]

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