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
>
>