Sorting on only certain characters in a cell

[Lesa]

I am trying to sort on a column that contains items such as the following:

P8692
LT6140
3511

The last 4 numbers are the last 4 of a VIN number and are the only ones I
want to sort on (would like to ignore the first characters and only sort on
the last 4).

Can anyone help?

 

[galimi]

Lesa,

In another column, enter the formula =right(a1,4)

Where a1 can be replaced with the cell value that contains the entire vin.
You can then sort on this new column.

 

[mcescher]

I am trying to sort on a column that contains items such as the following:

P8692
LT6140
3511

The last 4 numbers are the last 4 of a VIN number and are the only ones I
want to sort on (would like to ignore the first characters and only sort on
the last 4).

Can anyone help?

Assuming your data is in column A
You could insert a hidden column next to your data, and then us a
=Right(A1,4) to get the VIN and sort by it.

 

[Lesa]

Thanks you mcshcher and galimi! Worked just as you said!