I am trying to set up an inventory report for items which have serial
numbers, but have little experience with complicated formulas. The three
columns of the worksheet contain the starting number, the ending number and
the total in stock for each series. However, most of the serial numbers
contain letters, for example:

S2M478 S2M489 12
XV918N XV999N 82
DG12325 DG12339 15
9B2J8 9B9J9 72
AB280CC AB309CC 30

Is there a formula that will work with both numbers and letters? Id
appreciate any help. Thanks.