Generate Serial No.

Closed
AA - May 13, 2011 at 01:28 AM
 AA - May 13, 2011 at 02:26 AM
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.

1 reply

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
May 13, 2011 at 01:49 AM
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
1
can you please explain in detail?
0