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

Question

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 formatting.

Thanks for any help you can provide-

Heather

wumolad · Answer

Hi&nbsp;heatheratsunwest&nbsp;&nbsp;You can use RIGHT function to extract the last 6 numbers into another column. e.g&nbsp;&nbsp;=VALUE(RIGHT(A1,6))&nbsp;&nbsp;Then sort the column.&nbsp;Cheers

heatheratsunwest · Answer

wumoladThank you so much! Great idea!! Have a wonderful day!&nbsp;

wumolad · Answer

Hi&nbsp;heatheratsunwest&nbsp;&nbsp;Good to hear the post was useful. Please mark as the solution to close out the discussion.&nbsp;Cheers

cj1990 · Answer

wumolad&nbsp;loo

Forum Discussion

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

4 Replies

Resources