Previous Topic Next Topic

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 response

Answer 1 / 1
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
AA
May 13, 2011 at 02:26 AM
can you please explain in detail?
0

Similar discussions

App Password "This Feature isn't Available Right Now"
DavidS -
Enduroelm -

11 responses
need a serial number for Nero 6
DennisSamuels -
Ambucias -

1 response
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
Excel - To generate unique ID
wliang -
ferg -

4 responses
IDM SERIAL NUMBER
fisb -
Ambucias -

1 response