Generate Serial No.

AA - May 13, 2011 at 01:28 AM
 AA - May 13, 2011 at 02:26 AM

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:


Assume that the serial no in column A and start from Ist row
can you please explain in detail?