Number Sequencing

[joeydeacan]

Good morning,

Im trying to do some product codes, the groups are in groups of seven.

I wanted to do :-

9000 18SBLGA
9100 18SBLGB
9200 18SBLGC
9300 18SBLGG
9400 18SBLGMS
9500 18SBLGSH
9600 18SBLGSV

And then

9001 18SWHGA
9101 18SWHGB
9201 18SWHGC
9301 18SWHGG
9401 18SWHGMS
9501 18SWHGSH
9601 18SWHGSV

Any ideas on how this could be done not manually ?

Thanks
Ben

[Pete_UK]

Is that all in the same cell, or does it represent 2 columns? Better to attach a sample Excel workbook - the yellow banner at the top of the screen gives details of how to do this.

Pete