Assuming your first scan was in A1, second in A2, etc.......... put this in
B1 and copy over to the right and down as reqired

=LEFT(A1,5)&MID(A1,6,7)*1+1&RIGHT(A1,1)

Vaya con Dios,
Chuck, CABGx3



"asokol" wrote:


Hey guys I'm having a bit of trouble with a formula for barcodes.

I'm trying to get a sequence eg.

eg I will scan this barcode: HD65B1164281P
and it will go up like this HD65B1164282P
283P

for ten barcodes then i will scan another barcode and it needs to go
into another sequence for 9 barcodes....etc

Any help would be appreciated.


--
asokol
------------------------------------------------------------------------
asokol's Profile: http://www.excelforum.com/member.php...o&userid=29485
View this thread: http://www.excelforum.com/showthread...hreadid=491876