2
Suppose I have a number ED000071, I want the next numbers to be ED000072, ED000073, ED000074.........ED999999, EE000001. Could someone please help me to write a formula for this in Excel?
Tamil
Posted 2019-02-05T18:49:43.690
Reputation: 21
Need Auto Increment number beginning with Alphabet in Excel
Answers
0
You can use the following formula to change the numbers after the letters:
=(LEFT(A1,2)&TEXT((RIGHT(A1,6)+1),"000000"))
cybernetic.nomad
Posted 2019-02-05T18:49:43.690
Reputation: 4 469
Right now, you're not asking us to help you write the formula, your asking us to write the formula. What have you tried so far? – cybernetic.nomad – 2019-02-05T20:16:38.083
3There are "only" 1048576 rows in Excel, this means if you want them all in one column, you can start with
ED000071, but the sequence will end withEE048506– cybernetic.nomad – 2019-02-05T20:19:18.077So far I tried =(LEFT(A1,2)&(RIGHT(A1,6)+1)) – Tamil – 2019-02-05T21:19:45.597