Auto incrementing alphanumeric cell by 1
Solved/Closed
Related:
- Excel increment alphanumeric text
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel marksheet - Guide
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
Apr 15, 2011 at 10:31 PM
suppose this invoice number is in G1 in sheet1
in sheet 2 in G1 type this formula
=LEFT(Sheet1!G1,8)&MID(Sheet1!G1,9,4)+1&RIGHT(Sheet1!G1,4)
you will get
IND/APR/6735/INV
do something like this .
remember in May you have to change APR to MAY
in sheet 2 in G1 type this formula
=LEFT(Sheet1!G1,8)&MID(Sheet1!G1,9,4)+1&RIGHT(Sheet1!G1,4)
you will get
IND/APR/6735/INV
do something like this .
remember in May you have to change APR to MAY