Sort by part of a number

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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" έγγÏαψε:
 
Back
Top