Generate Serial No. Closed

Question

Hello, 

I want to generate serial no. against each record in excel.
Serial no. should be alphanumeric and is auto incremented.
e.g (XX-00001,XX-00002,.................)
Please solve this problem i shall be very thankful to you.

Configuration: Windows XP / Opera 9.80

RWomanizer · Answer

use the following formula: 

=LEFT(A1,2)&REPLACE((RIGHT(REPLACE(A1,3,1,1),6)+1),1,1,"-") 

Assume that the serial no in column A and start from Ist row

Generate Serial No.

1 response

Similar discussions

Subscribe To Our Newsletter!