Hi Guys,


This is probably the easiest fix in the world but I can't seem to find a good solution to this at the moment;
The issue I am having is that I need to create a database based on a scanned serial numbers, but only need certain information from these barcodes. An example of the kind of thing I am looking at;
Barcode: 41BLSTHOMAS9991987
From this Barcode i want to copy and paste the characters THOMAS and 1987 into Column B & C of that row. The barcode always has the same amount of characters and the characters are always in the same place (ie dates of birth will always be 4 characters long and will alway be the 15-18th characters).
Does anyone know any simple excel formula or VBA code that code do the above by any chance?

Thanks!