Sort

K

Kartal

Hi All;
I have a column (say A) in which there are some alpha-numeric chracacters
like below:

300-YT-102
300-YT-342
300-YT-204
300-YT-894
300-YT-454
.....

I want to sort it according to the last 3 digit so that I will have;

300-YT-102
300-YT-204
300-YT-342
300-YT-454
300-YT-894
....

How can I do that?
Thanks

Kartal
 
B

Bill Ridgeway

You need a helper column in which there is the formula
=RIGHT(A1,3) if the remainder of ALL the entries in the column are 300-YT-
=RIGHT(A1,3)&A1 if the remainder of the entries in the column are not all
300-YT-

and sort on the helper column.

Regards.

Bill Ridgeway
Computer Solutions
 
K

Kartal

Thank you...

Kartal
haber iletisinde þunlarý said:
You need a helper column in which there is the formula
=RIGHT(A1,3) if the remainder of ALL the entries in the column are
300-YT-
=RIGHT(A1,3)&A1 if the remainder of the entries in the column are not all
300-YT-

and sort on the helper column.

Regards.

Bill Ridgeway
Computer Solutions
Click to expand...
 
Top