How To Sort A List Of Vehicle Number Plates In Year Order In Excel 2010

You may think this is a peculiar topic, but it's an interesting one if you're a license plate dealer, or you keep lists of vehicles and you want to list the vehicles by licence plate date. As the UK license system changed in Sept 2001 we'll only look at sorting license plates lists issued after this date. License numbers since then take the form AB53 CRD or LN04 ABC where the first two letters indicate registration location and the following two numbers are the year identifiers. The final part consists of three random letters. We'll exclude personalised number plates which do not conform to these rules. So for these two examples the year identifiers are 53 and 04.

The full article appears here:
http://www.microsofttraining.net/article-1265-sort-list-vehicle-number-plates-year-order-excel-2010.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com