Need to sort a row by last 5 numbers only

[bobnmona]

Hello I have a situation where I have 101 rows and need to sort the vin column by the last 5 digits only is this possible?

Hello Unit # Qty Rcvd RMS Stk # Make Model Spec # Ord.# Ordered VIN Ship To / Upfitter

1 of 101 W4236 Chevy 2500 242FG02 SQNC30 6/2 1GB0CUEG1FZ548375 Phenix Stock w/switches
2 of 101 W4251 Chevy 2500 242FG02 SQNC31 6/2 1GB0CUEG9FZ548494 Phenix Stock w/switches
3 of 101 W4278 Chevy 2500 242FG02 SQNC32 6/2 1GB0CUEG3FZ548801 Phenix Stock w/switches
4 of 101 W4257 Chevy 2500 242FG02 SQNC33 6/2 1GB0CUEG0FZ548674 Phenix Stock w/switches
5 of 101 W4281 Chevy 2500 242FG02 SQNC34 6/2 1GB0CUEG2FZ548868 Phenix Stock w/switches
6 of 101 W4289 Chevy 2500 242FG02 SQNC35 6/2 1GB0CUEG9FZ548754 Phenix Stock w/switches
7 of 101 W4267 Chevy 2500 242FG02 SQNC36 6/2 1GB0CUEG5FZ548587 Phenix Stock w/switches
8 of 101 W4220 Chevy 2500 242FG02 SQNC37 6/2 1GB0CUEGXFZ548228 Phenix Stock

[Pete_UK]

Use another column to extract the last five digits of the VIN column, then include that column within your sort range and use it as the sort field. I can't easily tell which column you use for VIN, but assuming it is column L you would have this formula to extract the last five digits and turn them into numbers:

=RIGHT(L2,5)*1

Copy this down as far as you need to, then do your sort.

Hope this helps.

Pete