Hi,

Unfortunately there is no consistency in the alphanumeric string I.e. the
numeric portion is of variable length, the numeric portion does not appear
together.

We would have been able to formulate a solution if the numeric strings
appeared together.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"TeeTee" wrote in message
...
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.