Sorting VIN numbers.

**Nemesis708** · 10-21-2009, 11:47 AM

Hello and thanks for viewing.

I have a bunch of excel spreadsheets full of car VIN numbers and they were all entered manually. They are all supposed to be 17 characters long, but sometimes they are mistyped and end up being less or more than 17. I cant just sort ascending or filter because its not a visual problem. they all look different because of the different numbers and stuff.

Can someone please help me find a formula I can use to count each and every VIN in the column and sort them.

Thanks again for viewing.

PS. using Excel 2003

**Ron Coderre** · 10-21-2009, 11:53 AM

How do you want the irregular VIN numbers handled?
...please give some examples.

Also, can we assume that VIN "numbers" are actually alpha-numeric?

**Nemesis708** · 10-21-2009, 11:55 AM

3D7MX48C16G150213
2A8HR44E69R516378
1D4HB58236F129150
2G2WP5527811742<--- not enough characters.
1B3HB28BX8D697763
2C4GM68475R368010
5GAET13M472141 <-wrong
3C8FY68BX5T536569

If I can I would like them to be sorted into an asceding/descending order. I just need a count on each cell in the column making sure they are 17 characters long.