Forum Discussion

heatheratsunwest's avatar
heatheratsunwest
Copper Contributor
May 14, 2020

HELP! I need to sort by the last 6 of a VIN# in a column

Vin Numbers have a 11 digits of letters and numbers, and then the last 6 are always numbers. I want to sort by these. I am just not sure how to write a custom list or would it be conditional formatti...
excel
wumolad's avatar
wumolad
Iron Contributor
May 15, 2020

Hi heatheratsunwest 

 

You can use RIGHT function to extract the last 6 numbers into another column. e.g

 

 

=VALUE(RIGHT(A1,6))

 

 

Then sort the column.

 

Cheers

heatheratsunwest's avatar
heatheratsunwest
Copper Contributor
May 15, 2020

wumoladThank you so much! Great idea!! Have a wonderful day!

 

  • wumolad's avatar
    wumolad
    Iron Contributor
    May 15, 2020

    Hi heatheratsunwest 

     

    Good to hear the post was useful. Please mark as the solution to close out the discussion.

     

    Cheers

Resources