Sorting on only certain characters in a cell
 

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?

Sorting on only certain characters in a cell
 

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.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Lesa" wrote:

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?

Sorting on only certain characters in a cell
 

On Nov 25, 12:31*pm, Lesa wrote:
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.

Sorting on only certain characters in a cell
 

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

"mcescher" wrote:

On Nov 25, 12:31 pm, Lesa wrote:
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.