Sort by part of a number

[Guest]

I need to file by claim number where the number is P1- 358V-852

P1-358V-058

The correct order would be by the last three characters. Can this be done in
an easy way?

Thanking you in advance for any help.
Joe

 

[Guest]

Hello,
Without using VBA, somewhat difficult. However insert a nearby column in
which you will extract the 3 last numbers of your field, i.e. =RIGHT(A1;3),
then use the autofill to extract all rows. Finally use this column to sort
accordingly your records.

Hope this will help.

George

Ο χÏήστης "sacredarms" έγγÏαψε:

 

[Guest]

If this is something you have to do frequently, you might check out Jim
Cone's fine commercial Add-in called "Special Sort". It's available at

http://www.realezsites.com/bus/primitivesoftware/products.php

Vaya con Dios,
Chuck, CABGx3