Thread: Sorting on only certain characters in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lesa Lesa is offline
external usenet poster
  
Posts: 11
Default 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?
Reply With QuoteReply With Quote