Auto incrementing alphanumeric cell by 1

suryam - Apr 15, 2011 at 12:23 PM
 suryam - Apr 29, 2011 at 12:43 AM
I have an alpha numeric cell in excel sheet. for example IND/APR/6734/INV
I am using it to give number to the invoce that I generate everyday. once I finish the printing and saving the invoice , new invoice will come. I am manually incrementing the number in the third portion of the field. for example next number 6735 etc..Is there any method to auto increment it so that I can get IND/APR/6735/INV ... when I use the invoice template the next time. please help me . thanks suryam

4 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Apr 15, 2011 at 10:31 PM
suppose this invoice number is in G1 in sheet1
in sheet 2 in G1 type this formula


you will get


do something like this .

remember in May you have to change APR to MAY