View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mcescher mcescher is offline
external usenet poster
 
Posts: 24
Default 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.